Lawson Insight Technical Documentation |
|
NATBALANCE
NATBALANCE FILE
AR National Account Balance
The AR National Account Balance file contains summary information for a
national account customer. Balance, order and credit limit amounts are
examples of the type of information stored.
REFERENCED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 AR219 AR251 AR255 AR275
AR50.1 AR72.1 AR75.1 AR90.1 BL04.1 BL121
BL123 BL125 BL202 BL204 BL217 BL220
BL231 BL246 BL290 BL291 BL31.1 BL31.2
BL31.3 BL31.5 BL31.7 BL32.3 BL32.4 BL33.1
BL331 BL34.1 BL46.1 BL46.2 BL530 BL546
BL80.1 BL80.3 BL802 BL81.1 BL82.1 BL85.1
BL85.2 BL90.1 BR00.1 BR00.2 BR02.3 BR10.1
BR11.1 BR120 BR121 BR122 BR140 BR16.1
BR17.1 BR19.1 BR20.1 BR20.2 BR20.3 BR20.4
BR20.5 BR20.7 BR21.2 BR210 BR211 BR216
BR217 BR220 BR400 BR420 BR45.1 BR450
BR46.1 BR46.2 BR46.4 BR521 BRIP.1 CB06.2
IC02.1 IC28.1 IC531 MA180 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.1 MA67.2 MA70.1 MA75.1 MA80.1 MAI1.1
OE112 OE116 OE130 OE16.1 OE230 OE254
OE260 OE270 OE271 OE272 OE284 OE285
OE286 OE290 OE291 OE292 OE293 OE294
OE330 OE53.1 OE54.1 OE60.1 OE80.1 OE80.2
OE81.1 OE81.2 OE85.1 OE85.3 OE86.1 OE90.1
OE90.2 PBIP.1 PO100 PO101 PO122 PO131
PO20.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 POI3.1 POIE.1 POII.1 POIJ.1 PR197
RQ10.1 RQ10.2 SA03.1 SA100 SA252 SA254
SA256 SA261 SA271 SA281 SA291 SA300
SA80.2 SA90.2 TX140 TX40.1 WH110 WH120
WH130 WH132 WH190 WH21.2 WH224 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH33.5
WH34.1 WH34.2 WH34.3 WH34.4 WH40.1 WH40.2
WH520 WH830 WO30.1
UPDATED BY
AR09.1 AR10.1 AR112 AR115 AR12.1 AR12.2
AR124 AR129 AR13.1 AR13.2 AR130 AR131
AR135 AR137 AR161 AR17.1 AR170 AR180
AR190 AR199 AR20.1 AR21.1 AR21.2 AR21.3
AR24.1 AR28.1 AR29.1 AR29.2 AR29.3 AR30.1
AR30.8 AR301 AR31.6 AR33.1 AR33.3 AR33.6
AR34.1 AR35.1 AR35.2 AR37.1 AR37.2 AR37.3
AR37.4 AR37.5 AR37.6 AR37.7 AR42.1 AR42.2
AR42.6 AR42.7 AR43.1 AR44.3 AR48.3 AR501
AR502 AR505 AR550 AR560 AR570 AR575
AR580 AR70.2 AR80.1 AR80.2 AR82.1 ARLL.1
BL02.1 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL820
BL92.1 CB191 DT150 DT155 DT160 DT165
DT166 DT180 DT181 DT30.1 DT30.2 DT40.1
DT45.1 DT520 DT60.1 DT60.2 DT70.1 DT70.3
DT80.1 DT85.1 DT85.2 DT90.1 DT92.1 OE10.1
OE10.2 OE10.3 OE10.4 OE10.5 OE10.6 OE10.7
OE10.8 OE11.1 OE11.4 OE11.8 OE11.9 OE110
OE111 OE113 OE114 OE129 OE13.2 OE13.3
OE13.5 OE14.4 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE530
OE810 OE830 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
NAB-NAT-COMPANY Numeric 4 AR09.1 AR10.1
National Account National account customer's company AR12.1 AR12.2
Company number. AR301 AR501
AR505 AR550
BL02.1
NAB-NAT-CUSTOMER Alpha 9 (Right Justified) AR09.1 AR10.1
National Account National account customer number. AR12.1 AR12.2
Customer AR301 AR501
AR505 AR550
BL02.1
NAB-CURR-BAL Signed 18.2 AR09.1 AR10.1
Element: Intl Amt Current non bill of exchange balance of AR115 AR12.1
all customers in the national account AR12.2 AR124
relationship in customer group currency. AR129 AR13.1
AR13.2 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR28.1 AR29.1
AR29.2 AR29.3
AR30.1 AR30.8
AR301 AR31.6
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR501 AR502
AR505 AR550
AR560 AR570
AR575 AR580
AR80.1 AR80.2
AR82.1 ARLL.1
...
NAB-DRAFT-BAL Signed 18.2 AR10.1 AR115
Bill of Exchange Current bill of exchange balance for AR12.1 AR12.2
Balance all customers in the national account AR129 AR13.1
relationship in customer group currency. AR13.2 AR130
AR131 AR135
AR137 AR180
AR190 AR28.1
AR29.1 AR29.3
AR30.1 AR30.8
AR31.6 AR33.1
AR33.3 AR33.6
AR34.1 AR35.1
AR35.2 AR37.1
AR37.2 AR37.3
AR37.4 AR37.5
AR37.6 AR37.7
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR502
AR505 AR560
AR80.1 AR80.2
AR82.1 ARLL.1
DT150 DT155
DT160 DT165
DT166 DT180
DT181 DT30.1
DT30.2 DT40.1
DT45.1 DT520
DT60.1 DT60.2
...
NAB-OPEN-ORDS Signed 18.2 AR502 AR550
Element: Open Orders Open orders allowed for all national AR560 BL120
account customers. BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE129
OE13.2 OE13.3
OE13.5 OE14.4
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE530
OE810 OE830
WH20.7
NAB-CREDIT-LIM Signed 15.0 AR09.1 AR10.1
Element: Credit Limit National account customer's cumulative AR12.1 AR301
credit limit. AR501 AR550
BL02.1
NAB-CREDIT-LIM-DAT Numeric 8 (yyyymmdd) AR70.2
Element: Credit Limit DThis is the date that the national
account cumulative credit limit was
established.
NAB-REVIEW-DATE Numeric 8 (yyyymmdd) AR09.1 AR10.1
Element: Review Date This is the review date that is AR12.1 AR12.2
manually established for the national AR17.1 AR301
account. This may indicate the "next" or AR501 AR550
"last" review date depending on the AR70.2 BL02.1
review code.
NAB-REVIEW-CODE Alpha 1 AR17.1 AR170
Element: Review Date StThis indicates the status of the AR70.2
national account's review date. Valid
values are:
O = Open
R = Reviewed
NAB-HOLD-CODE Alpha 4 AR12.1 AR70.2
Element: Hold Code This indicates the hold code that has
been given to the national account.
NAB-HIGH-BAL Signed 15.0 Occurs 13 Times AR115 AR129
Vendor's Highest This is the highest balance that has AR13.1 AR13.2
Balance been recorded for each of the periods. AR130 AR131
AR135 AR137
AR180 AR190
AR199 AR28.1
AR29.1 AR29.2
AR29.3 AR30.1
AR30.8 AR31.6
AR33.1 AR33.3
AR33.6 AR34.1
AR35.1 AR35.2
AR37.1 AR37.2
AR37.3 AR37.4
AR37.5 AR37.6
AR37.7 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR501 AR502
AR560 AR80.1
AR80.2 AR82.1
ARLL.1 DT150
DT155 DT160
DT165 DT166
DT180 DT181
DT30.1 DT30.2
DT40.1 DT45.1
DT520 DT60.1
DT60.2 DT70.1
...
NAB-LAST-DUNN Numeric 2 AR161
Element: Last Dunning NThis is the last Dunning text number
that was issued to the national account
group.
NAB-LAST-DUN-DATE Numeric 8 (yyyymmdd) AR161
Element: Last Dunning DThis is the date of the last Dunning
text that was issued to the national
account group.
NAB-CURR-DRAFT-BAL Derived
Element: Current BOE BaCurrent balance of all customers in the
national account relationship in
customer group currency.
NATBALANCE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
NABSET1 NAT-COMPANY This is the primary path used to access AP125 AP126
NAT-CUSTOMER records. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AR09.1 AR10.1
AR112 AR115
AR12.1 AR12.2
AR124 AR129
AR13.1 AR13.2
AR130 AR131
AR135 AR137
AR161 AR17.1
AR170 AR180
AR190 AR199
AR20.1 AR21.1
...
|