 |
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 AP125 AP126 AP131 AP25.1 AP25.2
AP26.1 AP27.1 AR219 AR251 AR255 AR275
AR50.1 AR72.1 AR75.1 AR90.1 BR10.1 BR11.1
BR120 BR121 BR210 BR211 BR220 BR420
BR450 BRIP.1 CB06.2 IC02.1 IC28.1 IC531
MX223 MA180 MA43.9 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.3 MA67.1 MA67.2
MA70.1 MAI1.1 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 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
UPDATED BY
AR10.1 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.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
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 WH20.7
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
NAB-NAT-CUSTOMER Alpha 9 (Right Justified) AR10.1 AR12.1
National Account National account customer number. AR12.2 AR501
Customer AR505 AR550
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 AR129
relationship in customer group currency. 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.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 CB191
DT150 DT155
DT160 DT165
DT166 DT180
...
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 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.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
...
NAB-OPEN-ORDS Signed 15.2 AR502 AR550
Open Orders Open orders allowed for all national AR560 WH20.7
account customers.
NAB-CREDIT-LIM Signed 15.0 AR10.1 AR12.1
Credit Limit National account customer's cumulative AR550
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) AR10.1 AR12.1
Review Date This is the review date that is AR12.2 AR17.1
manually established for the national AR550 AR70.2
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 AR12.1 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.2
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 AR501
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
...
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 AP125
NAT-CUSTOMER records. AP126 AP131
AP25.1 AP25.2
AP26.1 AP27.1
AR10.1 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
...
|