NATBALANCE

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
AP510 API1.1 API2.1 AR11.1 AR210 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 BR49.1
BR51.1 BR51.2 BR52.1 BR52.2 BR521 BR53.1
BR55.2 BR70.1 BR70.2 BR91.1 BRIP.1 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 DR100 IC02.1 IC12.1
IC140 IC141 IC142 IC145 IC243 IC330
IC64.1 IC64.2 IC64.3 IC64.4 IC64.5 IC64.6
IC64.7 IC64.8 IC64.9 IC66.1 IC83.1 MA180
MA278 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA53.1 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
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 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO20.1 PO20.6
PO20.9 PO204 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO220 PO222
PO224 PO225 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO26.3 PO26.7 PO26.9 PO27.2 PO27.3 PO27.4
PO275 PO276 PO277 PO28.2 PO280 PO29.1
PO30.1 PO30.2 PO30.3 PO30.4 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 PO54.5 POCP.1
POI3.1 POID.1 POII.1 POIJ.1 RQ01.1 RQ10.1
RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
RQIB.1 RQIF.1 RQII.1 RQIJ.1 TX40.1 WH110
WH120 WH130 WH132 WH190 WH21.2 WH222
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 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830


UPDATED BY
AR09.1 AR10.1 AR12.1 AR12.2 AR13.1 AR13.2
AR17.1 AR301 AR501 AR550 ARLL.1 CB06.2
CB191 TX140 WH20.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
NAB-NAT-COMPANY
National Account
Company
Numeric 4
National account customer's company number.
AR09.1 AR10.1
AR12.1 AR12.2
AR301 AR501
AR550 TX140
NAB-NAT-CUSTOMER
National Account
Customer
Alpha 9 (Right Justified)
National account customer number.
AR09.1 AR10.1
AR12.1 AR12.2
AR301 AR501
AR550 TX140
NAB-CURR-BAL
Element: Intl Amt
Signed 18.2
Current non Bill of Exchange balance of all customers in the national account relationship in customer group currency.
AR09.1 AR10.1
AR12.1 AR12.2
AR13.1 AR13.2
AR301 AR501
AR550 ARLL.1
CB06.2 CB191
TX140
NAB-DRAFT-BAL
Bill of Exchange
Balance
Signed 18.2
Current Bill of Exchange balance for all customers in the national account relationship in customer group currency.
AR10.1 AR12.1
AR12.2 AR13.1
AR13.2 ARLL.1
CB06.2
NAB-OPEN-ORDS
Element: Open Orders
Signed 18.2
Open orders allowed for all national related national account customers in customer group currency.
AR550 ARLL.1
WH20.7
NAB-CREDIT-LIM
Element: Credit Limit
Signed 15.0
National account customer's cumulative credit limit for all customers in the national account relationship in customer group currency.
AR09.1 AR10.1
AR12.1 AR301
AR501 AR550
TX140
NAB-CREDIT-LIM-DAT
Element: Credit Limit Date
Numeric 8 (yyyymmdd)
This is the date that the national account cumulative credit limit was established.
NAB-REVIEW-DATE
Element: Review Date
Numeric 8 (yyyymmdd)
This is the review date that is manually established for the national account. This may indicate the "next" or "last" review date depending on the review code.
AR09.1 AR10.1
AR12.1 AR12.2
AR17.1 AR301
AR501 AR550
TX140
NAB-REVIEW-CODE
Element: Review Date Ststus
Alpha 1
This indicates the status of the national account's review date. Valid values are: O = Open R = Reviewed
AR17.1
NAB-HOLD-CODE
Element: Hold Code
Alpha 4
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.
AR12.1
NAB-HIGH-BAL
Element: High Bal
Signed 15.0 Occurs 13 Times
This is the highest balance that has been recorded for each of the last 13 periods.
AR13.1 AR13.2
AR501 ARLL.1
CB06.2
NAB-LAST-DUNN
Element: Last Dunning Number
Numeric 2
This is the last Dunning text number that was issued to the national account group.
NAB-LAST-DUN-DATE
Element: Last Dunning Date
Numeric 8 (yyyymmdd)
This is the date of the last Dunning text that was issued to the national account group.
NAB-CURR-DRAFT-BAL
Element: Current BOE Balance
Derived
Total current balance of all customers in the national account relationship in customer group currency.
NAB-STATEMENT-REQ
Element: Statement Req
Alpha 1

N = No
Y = Yes
AR12.1 AR12.2
NAB-INV-CUST-BF-BL
Element: Inv Cust Bf Bl
Alpha 1

N
I
NAB-STMNT-CYCLE
Element: Stmnt Cycle
Alpha 2
AR12.1 AR12.2
NAB-ZERO-STMNT-FL
Element: Zero Stmnt Fl
Alpha 1

N = No
Y = Yes
AR12.1 AR12.2
NAB-CRED-STMNT-FL
Element: Cred Stmnt Fl
Alpha 1

N = No
Y = Yes
AR12.1 AR12.2
NAB-PAST-STMNT-FL
Element: Past Stmnt Fl
Alpha 1

N = No
Y = Yes
AR12.1 AR12.2
NAB-OVER-STMNT-FL
Element: Over Stmnt Fl
Alpha 1

N = No
Y = Yes
AR12.1 AR12.2
NAB-NA-SUMMARY
Element: Na Summary
Alpha 1

N = No
Y = Yes
AR12.1 AR12.2
NAB-ALLOW-RETURNS
Element: All Flag
Alpha 1

" "
Y = Yes
N = No
L = Limit
AR12.1
NAB-ALLOW-RTN-DATE
Element: Date
Numeric 8 (yyyymmdd)
AR12.1


NATBALANCE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
NABSET1 NAT-COMPANY
NAT-CUSTOMER
...
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
AP510 API1.1
API2.1 AR09.1
AR09.4 AR10.1
AR11.1 AR12.1
AR12.2 AR13.1
AR13.2 AR17.1


File created: Thu Jun 09 02:09:13 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.