 |
Lawson Insight Technical Documentation |
|
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
AC551 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 BL80.1 BL80.3 BL802
BL81.1 BL82.1 BL85.1 BL85.2 BL90.1 BR10.1
BR11.1 BR120 BR121 BR210 BR211 BR220
BR420 BR450 BRIP.1 IC02.1 PR197 TX140
TX40.1 WH110 WH120 WH130 WH21.2 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
UPDATED BY
AR115 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.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 AR48.3 AR501 AR502
AR505 AR550 AR560 AR570 AR575 AR580
AR70.2 AR82.1 BL02.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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
NAB-NAT-COMPANY Numeric 4 AR501 AR505
National Account National account customer's company AR550 BL02.1
Company number.
NAB-NAT-CUSTOMER Alpha 9 (Right Justified) AR501 AR505
National Account National account customer number. AR550 BL02.1
Customer
NAB-CURR-BAL Signed 15.2 AR115 AR124
Current Balance Current non bill of exchange balance of AR129 AR13.1
all customers in the national account AR13.2 AR130
relationship in customer group currency. 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
AR48.3 AR502
AR505 AR550
AR560 AR570
AR575 AR580
AR82.1 BL02.1
CB191 DT150
DT155 DT160
DT165 DT166
DT180 DT181
DT30.1 DT30.2
...
NAB-DRAFT-BAL Signed 15.2 AR115 AR129
Bill of Exchange Current bill of exchange balance for AR13.1 AR13.2
Balance all customers in the national account AR130 AR131
relationship in customer group currency. 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
AR48.3 AR502
AR505 AR560
AR82.1 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-OPEN-ORDS Signed 15.2 AR502 AR550
Open Orders Open orders allowed for all national AR560
account customers.
NAB-CREDIT-LIM Signed 15.0 AR501 AR550
Credit Limit National account customer's cumulative BL02.1
credit limit.
NAB-CREDIT-LIM-DAT Numeric 8 (yyyymmdd) AR70.2
Credit Limit Date This is the date that the national
account cumulative credit limit was
established.
NAB-REVIEW-DATE Numeric 8 (yyyymmdd) AR17.1 AR501
Review Date This is the review date that is AR550 AR70.2
manually established for the national BL02.1
account. This may indicate the "next" or
"last" review date depending on the
review code.
NAB-REVIEW-CODE Alpha 1 AR17.1 AR170
Review Date Ststus This indicates the status of the AR70.2
national account's review date. Valid
values are:
O = Open
R = Reviewed
NAB-HOLD-CODE Alpha 4 AR70.2
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.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 AR48.3
AR502 AR560
AR82.1 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
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
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 AC551 AR115
NAT-CUSTOMER records. 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
AR219 AR24.1
AR251 AR255
AR275 AR28.1
AR29.1 AR29.3
AR30.1 AR30.2
...
|