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
AC56.1 AC560 AP125 AP126 AP131 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.4
API1.1 AR219 AR251 AR255 AR275 AR50.1
AR72.1 AR75.1 AR90.1 BL04.1 BL10.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 BL81.1 BL82.1 BL85.1 BL85.2
BL90.1 BR00.1 BR00.2 BR02.3 BR10.1 BR10.9
BR11.1 BR120 BR121 BR122 BR123 BR140
BR151 BR152 BR155 BR156 BR16.1 BR16.2
BR17.1 BR180 BR19.1 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR20.7 BR21.2 BR210 BR211
BR216 BR217 BR220 BR251 BR252 BR253
BR400 BR420 BR45.1 BR450 BR46.1 BR46.2
BR46.4 BR51.1 BR51.2 BR52.1 BR52.2 BR521
BR53.1 BR55.2 BR70.1 BR70.2 BR91.1 BRIP.1
IC02.1 MA180 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 POI3.1 POID.1 POII.1 POIJ.1 PW110
RQ10.1 RQ10.2 TX40.1 WH110 WH120 WH130
WH132 WH190 WH21.2 WH224 WH226 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
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 AR32.1 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 AR38.1 AR38.2
AR38.3 AR39.1 AR39.2 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 AR800 AR82.1 ARLL.1
BL02.1 BL120 BL122 BL130 BL20.1 BL20.3
BL21.2 BL21.5 BL29.1 BL29.2 BL520 BL802
BL820 BL92.1 CB06.2 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 PW550 TX140 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 BL802
PW550 TX140
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 BL802
PW550 TX140
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 AR129 AR13.1
currency. 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 AR32.1
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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR501
AR502 AR505
AR550 AR560
AR570 AR575
...
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 AR20.1
AR21.1 AR21.2
AR21.3 AR28.1
AR29.1 AR29.3
AR30.1 AR30.8
AR32.1 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
AR38.1 AR38.2
AR38.3 AR39.1
AR39.2 AR42.1
AR42.2 AR42.6
AR42.7 AR43.1
AR44.3 AR48.3
AR502 AR505
AR560 AR80.1
AR80.2 AR800
AR82.1 ARLL.1
CB06.2 DT150
DT155 DT160
...
NAB-OPEN-ORDS Signed 18.2 AR502 AR550
Element: Open Orders Open orders allowed for all national AR560 ARLL.1
related national account customers in BL120 BL122
customer group currency. BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
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 for all customers in the AR501 AR550
national account relationship in BL02.1 BL802
customer group currency. PW550 TX140
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. BL802 PW550
TX140
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.
The national account hold code is
informational data for an external order
processing system. Accounts Receivable
does not prevent any processing for
customers on hold.
NAB-HIGH-BAL Signed 15.0 Occurs 13 Times AR115 AR129
Element: High Bal This is the highest balance that has AR13.1 AR13.2
been recorded for each of the last 13 AR130 AR131
periods. AR135 AR137
AR180 AR190
AR199 AR20.1
AR21.1 AR21.2
AR21.3 AR28.1
AR29.1 AR29.2
AR29.3 AR30.1
AR30.8 AR32.1
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 AR38.1
AR38.2 AR38.3
AR39.1 AR39.2
AR42.1 AR42.2
AR42.6 AR42.7
AR43.1 AR44.3
AR48.3 AR501
AR502 AR560
AR80.1 AR80.2
AR800 AR82.1
ARLL.1 CB06.2
DT150 DT155
DT160 DT165
...
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 BaTotal 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 AC56.1 AC560
NAT-CUSTOMER AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 AR09.1
AR10.1 AR112
AR115 AR12.1
AR12.2 AR124
AR129 AR13.1
AR13.2 AR130
...
|