NATACCT

Accounts Receivable Natl Acct

The AR National Account file contains national account records that identify payment relationships between customers. Invoiced customers must be in the same customer group as the national account customer. National account relationships are alo used in Aging reports and customer Statements.

REFERENCED BY
AR212 ARLL.1 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
AR13.1 AR13.2 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 CB06.2 CB191 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 WH20.1 WH20.2
WH20.7 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 AR01.1


UPDATED BY
AR09.1 AR10.1 AR12.1 AR12.2 AR301 AR501
AR550 TX140

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
NAC-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
NAC-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
NAC-COMPANY
Element: Company
Numeric 4
Invoiced customer's company number.
AR09.1 AR10.1
AR12.1 AR12.2
AR301 AR501
AR550 TX140
NAC-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Invoiced customer's customer number.
AR09.1 AR10.1
AR12.1 AR12.2
AR301 AR501
AR550 TX140
NAC-NA-TRAN-STATUS
Element: Status
Numeric 1
Determines whether to add and delete national account transaction records in AR12 National Account or in AR112 National Account Transaction Update, based on a company processing option. Valid values are: 1 = AR112 will add transactions 2 = AR112 will delete transactions
0 = Initialized value
3 = Establish relationship
AR12.1 AR12.2


NATACCT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
NACSET1 NAT-COMPANY
NAT-CUSTOMER
COMPANY
CUSTOMER
AR09.1 AR10.1
AR12.1 AR12.2
AR212 AR301
AR501 AR550
ARLL.1 TX140
NACSET2 COMPANY
CUSTOMER
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 AR210
NACSET3 NAT-COMPANY
NAT-CUSTOMER
COMPANY
CUSTOMER
Subset
WhereNAT-COMPANY !=COMPANY
NACSET4 NAT-COMPANY
NAT-CUSTOMER
COMPANY
CUSTOMER
Subset
WhereNA-TRAN-STATUS !=Zeroes
AR01.1 AR12.1
AR12.2


NATACCT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
NAC-NAT-COMPANY->ACO-COMPANY
Arinvcomp ARCOMP Required
NAC-COMPANY->ACO-COMPANY
Custdesc CUSTDESC Required
ACO-CUST-GROUP->CUD-CUST-GROUP
NAC-NAT-CUSTOMER->CUD-CUSTOMER
Incustdesc CUSTDESC Required
ACO-CUST-GROUP->CUD-CUST-GROUP
NAC-CUSTOMER->CUD-CUSTOMER
Invcustomer ARCUSTOMER Required
NAC-COMPANY->ACM-COMPANY
NAC-CUSTOMER->ACM-CUSTOMER
Natbalance NATBALANCE Required
NAC-NAT-COMPANY->NAB-NAT-COMPANY
NAC-NAT-CUSTOMER->NAB-NAT-CUSTOMER


NATACCT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Invoitems AROITEMS
NAC-COMPANY->ARO-COMPANY
NAC-CUSTOMER->ARO-CUSTOMER
  ARO-TRANS-DATE
  ARO-TRANS-TYPE
  ARO-INVOICE
  ARO-PAYMENT-SEQ
Natoitems AROITEMS
NAC-NAT-COMPANY->ARO-COMPANY
NAC-NAT-CUSTOMER->ARO-CUSTOMER
  ARO-TRANS-DATE
  ARO-TRANS-TYPE
  ARO-INVOICE
  ARO-PAYMENT-SEQ


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

Home
Contact Us



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