NATBALANCE FILE
AR National Account Balance
AR National Account Balance
REFERENCED BY
AC115 AC15.2 AC450 AR251 AR255 AR275
AR50.1 AR73.1 AR75.1 BL04.1 BL120 BL121
BL122 BL123 BL130 BL20.1 BL20.3 BL202
BL204 BL21.2 BL21.5 BL220 BL231 BL246
BL29.1 BL29.2 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 BL520 BL80.1
BL80.3 BL802 BL81.1 BL820 BL85.1 BL85.2
BL90.1 BL902 BL940 OE112 OE130 OE230
OE254 OE260 OE270 OE271 OE272 OE284
OE285 OE286 OE290 OE291 OE292 OE293
OE294 OE30.1 OE30.2 OE30.3 OE30.4 OE30.5
OE30.6 OE30.7 OE30.9 OE330 OE53.1 OE54.1
OE60.1 OE80.1 OE80.2 OE81.1 OE81.2 OE830
OE85.1 OE90.1 OE90.2 OE950 PBIP.1 SA03.1
SA100 SA252 SA254 SA256 SA261 SA271
SA281 SA291 SA300 SA80.2 SA90.2 TX140
TX40.1 WH110 WH120 WH21.2
UPDATED BY
AR10.1 AR115 AR12.1 AR12.2 AR124 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.3 AR30.1 AR30.2 AR30.3 AR30.4 AR30.8
AR301 AR31.6 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 AR501
AR502 AR505 AR550 AR560 AR570 AR575
AR580 AR70.2 AR82.1 AR973 BL02.1 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 OE113
OE114 OE129 OE14.4 OE15.1 OE15.2 OE15.3
OE15.4 OE15.5 OE15.7 OE510 OE810 OE920
WH130 WH132 WH190 WH20.7 WH30.1 WH30.2
WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2
WH32.3 WH33.5 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
NAB-NAT-COMPANY Numeric 4 AR10.1 AR12.1
National Account National account customer's company AR12.2 AR501
Company number. AR505 AR550
AR973 BL02.1
NAB-NAT-CUSTOMER Alpha 9 (Right Justified) AR10.1 AR12.1
National Account National account customer number. AR12.2 AR501
Customer AR505 AR550
AR973 BL02.1
NAB-CURR-BAL Signed 15.2 AR10.1 AR115
Current Balance Current non bill of exchange balance of AR12.1 AR12.2
all customers in the national account AR124 AR13.1
relationship in customer group currency. AR13.2 AR130
AR131 AR135
AR137 AR180
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR28.1 AR29.1
AR29.3 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.6 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
AR502 AR505
AR550 AR560
AR570 AR575
AR580 AR82.1
AR973 BL02.1
CB191 DT150
DT155 DT160
DT165 DT166
DT180 DT181
...
NAB-DRAFT-BAL Signed 15.2 AR10.1 AR115
Bill of Exchange Current bill of exchange balance for AR12.1 AR12.2
Balance all customers in the national account AR13.1 AR13.2
relationship in customer group currency. AR130 AR131
AR135 AR137
AR180 AR190
AR28.1 AR29.1
AR29.3 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.6 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
AR502 AR505
AR560 AR82.1
AR973 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
...
NAB-OPEN-ORDS Signed 15.2 AR502 AR550
Open Orders Open orders allowed for all national AR560 AR973
account customers. 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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE510 OE810
OE920 WH130
WH132 WH190
WH20.7 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
WH33.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
NAB-CREDIT-LIM Signed 15.0 AR10.1 AR12.1
Credit Limit National account customer's cumulative AR501 AR550
credit limit. AR973 BL02.1
NAB-CREDIT-LIM-DAT Numeric 8 (yyyymmdd) AR70.2 AR973
Credit Limit Date This is the date that the national
account cumulative credit limit was
established.
NAB-REVIEW-DATE Numeric 8 (yyyymmdd) AR10.1 AR12.1
Review Date This is the review date that is AR12.2 AR17.1
manually established for the national AR501 AR550
account. This may indicate the "next" or AR70.2 AR973
"last" review date depending on the BL02.1
review code.
NAB-REVIEW-CODE Alpha 1 AR17.1 AR170
Review Date Status This indicates the status of the AR70.2 AR973
national account's review date. Valid
values are:
O = Open
R = Reviewed
NAB-HOLD-CODE Alpha 4 AR12.1 AR70.2
Hold Code This indicates the hold code that has AR973
been given to the national account.
NAB-HIGH-BAL Signed 15.0 Occurs 13 Times AR115 AR13.1
Vendor's Highest This is the highest balance that has AR13.2 AR130
Balance been recorded for each of the periods. AR131 AR135
AR137 AR180
AR190 AR199
AR28.1 AR29.1
AR29.3 AR30.1
AR30.2 AR30.3
AR30.4 AR30.8
AR31.6 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
AR502 AR560
AR82.1 AR973
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
NAB-LAST-DUNN Numeric 2 AR161 AR973
Last Dunning Number This is the last Dunning text number
that was issued to the national account
group.
NAB-LAST-DUN-DATE Numeric 8 (yyyymmdd) AR161 AR973
Last Dunning Date This is the date of the last Dunning
text that was issued to the national
account group.
NAB-CURR-DRAFT-BAL Derived
Current BOE Balance Current 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 AC115 AC15.2
NAT-CUSTOMER records. AC450 AR10.1
AR115 AR12.1
AR12.2 AR124
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 AR251
AR255 AR275
AR28.1 AR29.1
...
|