JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

Implementation Guides | 920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

210 COLUMNS | 7 INDEXES | Print definition?920 | 03 | F03012 TABLE

03: Accounts Receivable
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F03012AI2107Customer Master by Line of BusinessMaster Files03: Accounts Receivable
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT AIAN8, AICO, AIARC, AIMCUR, AIOBAR, AIAIDR, AIKCOR, AIDCAR, AIDTAR, AICRCD, AITXA1, AIEXR1, AIACL, AIHDAR, AITRAR, AISTTO, AIRYIN, AISTMT, AIARPY, AIATCS, AISITO, AISQNL, AIALGM, AICYCN, AIBO, AITSTA, AICKHC, AIDLC, AIDNLT, AIPLCR, AIRVDJ, AIDSO, AICMGR, AICLMG, AIDLQT, AIDLQJ, AINBRR, AICOLL, AINBR1, AINBR2, AINBR3, AINBCL, AIAFC, AIFD, AIFP, AICFCE, AIAB2, AIDT1J, AIDFIJ, AIDLIJ, AIABC1, AIABC2, AIABC3, AIFNDJ, AIDLP, AIDB, AIDNBJ, AITRW, AITWDJ, AIAVD, AICRCA, AIAD, AIAFCP, AIAFCY, AIASTY, AISPYE, AIAHB, AIALP, AIABAM, AIABA1, AIAPRC, AIMAXO, AIMINO, AIOYTD, AIOPY, AIPOPN, AIDAOJ, AIAN8R, AIBADT, AICPGP, AIORTP, AITRDC, AIINMG, AIEXHD, AIHOLD, AIROUT, AISTOP, AIZON, AICARS, AIDEL1, AIDEL2, AILTDT, AIFRTH, AIAFT, AIAPTS, AISBAL, AIBACK, AIPORQ, AIPRIO, AIARTO, AIINVC, AIICON, AIBLFR, AINIVD, AILEDJ, AIPLST, AIMORD, AICMC1, AICMR1, AICMC2, AICMR2, AIPALC, AIVUMD, AIWUMD, AIEDPM, AIEDII, AIEDCI, AIEDQD, AIEDAD, AIEDF1, AIEDF2, AISI01, AISI02, AISI03, AISI04, AISI05, AIURCD, AIURAT, AIURAB, AIURDT, AIURRF, AICP01, AIASN, AIDSPA, AICRMD, AIPLY, AIMAN8, AIARL, AIAMCR, AIAC01, AIAC02, AIAC03, AIAC04, AIAC05, AIAC06, AIAC07, AIAC08, AIAC09, AIAC10, AIAC11, AIAC12, AIAC13, AIAC14, AIAC15, AIAC16, AIAC17, AIAC18, AIAC19, AIAC20, AIAC21, AIAC22, AIAC23, AIAC24, AIAC25, AIAC26, AIAC27, AIAC28, AIAC29, AIAC30, AISLPG, AISLDW, AICFPP, AICFSP, AICFDF, AIRQ01, AIRQ02, AIDR03, AIDR04, AIRQ03, AIRQ04, AIRQ05, AIRQ06, AIRQ07, AIRQ08, AIDR08, AIDR09, AIRQ09, AIUSER, AIPID, AIUPMJ, AIUPMT, AIJOBN, AIPRGF, AIBYAL, AIBSC, AIASHL, AIPRSN, AIOPBO, AIAPSB, AITIER1, AIPWPCP, AICUSTS, AISTOF, AITERRID, AICIG, AITORG, AIDTEE, AISYNCS, AICAAD, AIGOPASF FROM F03012

TOP920 | 03 | F03012 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1AIAN8Address NumberNumericGeneric Edit80 Allow NULL? 
2AICOCompanyStringGeneric Edit50 Allow NULL? 
3AIARCG/L OffsetStringGeneric Edit40 Allow NULL? 
4AIMCURBusiness Unit - A/R DefaultStringGeneric Edit120 Allow NULL? 
5AIOBARObject - Accounts Receivable DefaultStringGeneric Edit60 Allow NULL? 
6AIAIDRSubsidiary - Accounts Receivable DefaultStringGeneric Edit80 Allow NULL? 
7AIKCORDocument Company (A/R Model Document)StringGeneric Edit50 Allow NULL? 
8AIDCARDocument - A/R Default for Model JENumericGeneric Edit80 Allow NULL? 
9AIDTARDocument Type - A/R Default for Model JEStringUDC (00 DT)20 Allow NULL? 
10AICRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
11AITXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
12AIEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
13AIACLAmount - Credit LimitNumericGeneric Edit150 Allow NULL? 
14AIHDARHold InvoicesCharacterUDC (H01 HC)10 Allow NULL? 
15AITRARPayment Terms - A/RStringGeneric Edit30 Allow NULL? 
16AISTTOSend Statement to C/PCharacterUDC (H00 SV)10 Allow NULL? 
17AIRYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
18AISTMTPrint Statement Y/NCharacterUDC (H03 ST)10 Allow NULL? 
19AIARPYAlternate PayorNumericGeneric Edit80 Allow NULL? 
20AIATCSAuto Receipt (Y/N)CharacterGeneric Edit10 Allow NULL? 
21AISITOSend Invoice to C/PCharacterUDC (H00 SI)10 Allow NULL? 
22AISQNLLedger Inquiry SequenceCharacterUDC (H01 SQ)10 Allow NULL? 
23AIALGMAuto Receipt Algorithm MethodStringUDC (01 AA)20 Allow NULL? 
24AICYCNStatement CycleStringGeneric Edit20 Allow NULL? 
25AIBOBalance Forward-Open ItemCharacterUDC (H03 BO)10 Allow NULL? 
26AITSTATemporary Credit MessageStringUDC (00 CM)20 Allow NULL? 
27AICKHCCredit Check Handling CodeCharacterGeneric Edit10 Allow NULL? 
28AIDLCDate - Last Credit ReviewDateGeneric Edit60
29AIDNLTDelinquency Notice (Y/N)CharacterGeneric Edit10 Allow NULL? 
30AIPLCRPerson Completing Last Credit Limit RevStringGeneric Edit100 Allow NULL? 
31AIRVDJDate - Recall for ReviewDateGeneric Edit60
32AIDSODays Sales OutstandingNumericGeneric Edit50 Allow NULL? 
33AICMGRCredit ManagerStringUDC (01 CR)100 Allow NULL? 
34AICLMGCollection ManagerStringUDC (01 CM)100 Allow NULL? 
35AIDLQTDunning Letters - Number SentNumericGeneric Edit30 Allow NULL? 
36AIDLQJDate - Last Dunning LetterDateGeneric Edit60
37AINBRRReminders - Number of Reminders to SendCharacterUDC (H00 NB)10 Allow NULL? 
38AICOLLCollection Report (Y/N)CharacterUDC (H00 CO)10 Allow NULL? 
39AINBR1Number of Sent Reminders - 1NumericGeneric Edit30 Allow NULL? 
40AINBR2Number of Sent Reminders - 2NumericGeneric Edit30 Allow NULL? 
41AINBR3Number of Sent Reminders - 3NumericGeneric Edit30 Allow NULL? 
42AINBCLNumber of Invoices to Collection ReportNumericGeneric Edit30 Allow NULL? 
43AIAFCApply Finance Charges - Y/NCharacterUDC (H00 AF)10 Allow NULL? 
44AIFDFinance Charge DaysNumericGeneric Edit30 Allow NULL? 
45AIFPPercentage FactorNumericGeneric Edit96 Allow NULL? 
46AICFCEFinance Charge - Create Entries Y/NCharacterGeneric Edit10 Allow NULL? 
47AIAB2Address Book - Pending Cash ReceiptsCharacterGeneric Edit10 Allow NULL? 
48AIDT1JDate - Last Statement DateDateGeneric Edit60
49AIDFIJDate - First InvoiceDateGeneric Edit60
50AIDLIJDate - Last Invoice (Julian)DateGeneric Edit60
51AIABC1ABC Code SalesCharacterUDC (H01 A1)10 Allow NULL? 
52AIABC2ABC Code 2 - Investment - InventoryCharacterUDC (H01 A2)10 Allow NULL? 
53AIABC3ABC Code Average DaysCharacterUDC (H01 A3)10 Allow NULL? 
54AIFNDJDate - Financial Stmts on HandDateGeneric Edit60
55AIDLPDate - Last PaidDateGeneric Edit60
56AIDBDun & Bradstreet RatingStringUDC (01 DB)30 Allow NULL? 
57AIDNBJDate - Dun & BradstreetDateGeneric Edit60
58AITRWTRW RatingStringUDC (01 TR)30 Allow NULL? 
59AITWDJTRW DateDateGeneric Edit60
60AIAVDAverage Days LateNumericGeneric Edit30 Allow NULL? 
61AICRCACurrency Code - A/B AmountsStringGeneric Edit30 Allow NULL? 
62AIADAmount - DueNumericGeneric Edit152 Allow NULL? 
63AIAFCPAmount - Prior Year Finance ChargesNumericGeneric Edit152 Allow NULL? 
64AIAFCYAmount - YTD Finance ChargesNumericGeneric Edit152 Allow NULL? 
65AIASTYAmount - Invoiced This YearNumericGeneric Edit152 Allow NULL? 
66AISPYEAmount - Invoiced Prior YearNumericGeneric Edit152 Allow NULL? 
67AIAHBAmount - High BalanceNumericGeneric Edit152 Allow NULL? 
68AIALPAmount - Last AppliedNumericGeneric Edit152 Allow NULL? 
69AIABAMAmount - Address BookNumericGeneric Edit152 Allow NULL? 
70AIABA1Amount - Address BookNumericGeneric Edit152 Allow NULL? 
71AIAPRCAmount - Open OrderNumericGeneric Edit152 Allow NULL? 
72AIMAXOMaximum Order ValueNumericGeneric Edit150 Allow NULL? 
73AIMINOMinimum Order ValueNumericGeneric Edit150 Allow NULL? 
74AIOYTDOrders - Year-to-DateNumericGeneric Edit30 Allow NULL? 
75AIOPYOrders - Prior YearNumericGeneric Edit30 Allow NULL? 
76AIPOPNPerson Opening AccountStringGeneric Edit100 Allow NULL? 
77AIDAOJDate - Account OpenedDateGeneric Edit60
78AIAN8RRelated - Address NumberNumericGeneric Edit80 Allow NULL? 
79AIBADTBilling Address TypeCharacterUDC (H42 BA)10 Allow NULL? 
80AICPGPCustomer Price GroupStringUDC (40 PC)80 Allow NULL? 
81AIORTPOrder TemplateStringUDC (40 OT)80 Allow NULL? 
82AITRDCDiscount - TradeNumericGeneric Edit73 Allow NULL? 
83AIINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
84AIEXHDCredit Hold ExemptCharacterGeneric Edit10 Allow NULL? 
85AIHOLDHold Orders CodeStringUDC (42 HC)20 Allow NULL? 
86AIROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
87AISTOPStop CodeStringUDC (42 SP)30 Allow NULL? 
88AIZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
89AICARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
90AIDEL1Delivery Instructions Line 1StringGeneric Edit300 Allow NULL? 
91AIDEL2Delivery Instructions Line 2StringGeneric Edit300 Allow NULL? 
92AILTDTTransit DaysNumericGeneric Edit50 Allow NULL? 
93AIFRTHFreight Handling CodeStringUDC (42 FR)30 Allow NULL? 
94AIAFTApply Freight - Y/NCharacterGeneric Edit10 Allow NULL? 
95AIAPTSPartial Line Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
96AISBALSubstitutes Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
97AIBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
98AIPORQCustomer PO Required (Y/N)CharacterGeneric Edit10 Allow NULL? 
99AIPRIOPriority - ProcessingCharacterUDC (H40 PR)10 Allow NULL? 
100AIARTOCredit Check LevelCharacterUDC (H42 AR)10 Allow NULL? 
101AIINVCInvoice CopiesNumericGeneric Edit20 Allow NULL? 
102AIICONInvoice ConsolidationCharacterGeneric Edit10 Allow NULL? 
103AIBLFRBilling FrequencyCharacterUDC (H42 BL)10 Allow NULL? 
104AINIVDNext Invoice DateDateGeneric Edit60
105AILEDJDate - License ExpirationDateGeneric Edit60
106AIPLSTPrice Pick List (Y/N)CharacterGeneric Edit10 Allow NULL? 
107AIMORDMerge Orders (Y/N)CharacterGeneric Edit10 Allow NULL? 
108AICMC1Commission Code 1NumericGeneric Edit80 Allow NULL? 
109AICMR1Rate - Commission 1NumericGeneric Edit73 Allow NULL? 
110AICMC2Commission Code 2NumericGeneric Edit80 Allow NULL? 
111AICMR2Rate - Commission 2NumericGeneric Edit73 Allow NULL? 
112AIPALCPallet ControlCharacterGeneric Edit10 Allow NULL? 
113AIVUMDUnit of Measure - Volume DisplayStringUDC (00 UM)20 Allow NULL? 
114AIWUMDUnit of Measure - Weight DisplayStringUDC (00 UM)20 Allow NULL? 
115AIEDPMBatch Processing ModeCharacterUDC (H40 EE)10 Allow NULL? 
116AIEDIIItem Type IdentifierCharacterUDC (40 II)10 Allow NULL? 
117AIEDCICustomer Type IdentifierCharacterUDC (40 CI)10 Allow NULL? 
118AIEDQDQuantity DecimalsNumericGeneric Edit10 Allow NULL? 
119AIEDADAmount DecimalsNumericGeneric Edit10 Allow NULL? 
120AIEDF1Delivery NoteCharacterGeneric Edit10 Allow NULL? 
121AIEDF2Item RestrictionsCharacterUDC (H40 ED)10 Allow NULL? 
122AISI01Partial Order Shipments Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
123AISI02COA Print (Y/N)CharacterGeneric Edit10 Allow NULL? 
124AISI03Override Territory Id AssignmentCharacterGeneric Edit10 Allow NULL? 
125AISI04Special Instruction 04CharacterGeneric Edit10 Allow NULL? 
126AISI05Special Instruction 05CharacterGeneric Edit10 Allow NULL? 
127AIURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
128AIURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
129AIURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
130AIURDTUser Reserved DateDateGeneric Edit60
131AIURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
132AICP01Sales Price Based On DateCharacterUDC (40 DB)10 Allow NULL? 
133AIASNPrice and Adjustment ScheduleStringUDC (40 AS)80 Allow NULL? 
134AIDSPAPrint Adjustments on Invoice (Y/N)CharacterGeneric Edit10 Allow NULL? 
135AICRMDSend MethodCharacterUDC (00 SM)10 Allow NULL? 
136AIPLYPolicy Number (Internal)NumericGeneric Edit50 Allow NULL? 
137AIMAN8Deduction ManagerNumericGeneric Edit80 Allow NULL? 
138AIARLAuto Receipts Execution ListStringGeneric Edit100 Allow NULL? 
139AIAMCRAdministration Credit LimitNumericGeneric Edit150 Allow NULL? 
140AIAC01Category Code - Address Book 01StringUDC (01 01)30 Allow NULL? 
141AIAC02Category Code - Address Book 02StringUDC (01 02)30 Allow NULL? 
142AIAC03Category Code - Address Book 03StringUDC (01 03)30 Allow NULL? 
143AIAC04Category Code - Address Book 04StringUDC (01 04)30 Allow NULL? 
144AIAC05Category Code - Address Book 05StringUDC (01 05)30 Allow NULL? 
145AIAC06Category Code - Address Book 06StringUDC (01 06)30 Allow NULL? 
146AIAC07Category Code - Address Book 07StringUDC (01 07)30 Allow NULL? 
147AIAC08Category Code - Address Book 08StringUDC (01 08)30 Allow NULL? 
148AIAC09Category Code - Address Book 09StringUDC (01 09)30 Allow NULL? 
149AIAC10Category Code - Address Book 10StringUDC (01 10)30 Allow NULL? 
150AIAC11Sales RegionStringUDC (01 11)30 Allow NULL? 
151AIAC12Category Code - Address Book 12StringUDC (01 12)30 Allow NULL? 
152AIAC13Category Code - Address Book 13StringUDC (01 13)30 Allow NULL? 
153AIAC14Category Code - Address Book 14StringUDC (01 14)30 Allow NULL? 
154AIAC15Category Code - Address Book 15StringUDC (01 15)30 Allow NULL? 
155AIAC16Category Code - Address Book 16StringUDC (01 16)30 Allow NULL? 
156AIAC17Category Code - Address Book 17StringUDC (01 17)30 Allow NULL? 
157AIAC18Category Code - Address Book 18StringUDC (01 18)30 Allow NULL? 
158AIAC19Category Code - Address Book 19StringUDC (01 19)30 Allow NULL? 
159AIAC20Category Code - Address Book 20StringUDC (01 20)30 Allow NULL? 
160AIAC21Category Code - Address Book 21StringUDC (01 21)30 Allow NULL? 
161AIAC22Category Code - Address Book 22StringUDC (01 22)30 Allow NULL? 
162AIAC23Category Code - Address Book 23StringUDC (01 23)30 Allow NULL? 
163AIAC24Category Code - Address Book 24StringUDC (01 24)30 Allow NULL? 
164AIAC25Category Code - Address Book 25StringUDC (01 25)30 Allow NULL? 
165AIAC26Category Code - Address Book 26StringUDC (01 26)30 Allow NULL? 
166AIAC27Category Code - Address Book 27StringUDC (01 27)30 Allow NULL? 
167AIAC28Category Code - Address Book 28StringUDC (01 28)30 Allow NULL? 
168AIAC29Category Code - Address Book 29StringUDC (01 29)30 Allow NULL? 
169AIAC30Category Code - Address Book 30StringUDC (01 30)30 Allow NULL? 
170AISLPGProgram Name - Shipping LabelsStringGeneric Edit100 Allow NULL? 
171AISLDWVersion Name - Shipping Label ProgramStringGeneric Edit100 Allow NULL? 
172AICFPPConfiguration Pick and PackStringGeneric Edit180 Allow NULL? 
173AICFSPConfiguration Standard Carton PackStringGeneric Edit180 Allow NULL? 
174AICFDFDefault ConfigurationCharacterGeneric Edit10 Allow NULL? 
175AIRQ01Requires Packaging CodeCharacterGeneric Edit10 Allow NULL? 
176AIRQ02Requires Weight CodeCharacterGeneric Edit10 Allow NULL? 
177AIDR03Default Identification Code Qualifier 1StringUDC (41 X3)20 Allow NULL? 
178AIDR04Default Identification Code Qualifier 2StringUDC (41 X3)20 Allow NULL? 
179AIRQ03Requires Identification - Code 1CharacterGeneric Edit10 Allow NULL? 
180AIRQ04Requires Identification - Code 2CharacterGeneric Edit10 Allow NULL? 
181AIRQ05Requires Transportation MethodCharacterGeneric Edit10 Allow NULL? 
182AIRQ06Requires RoutingCharacterGeneric Edit10 Allow NULL? 
183AIRQ07Requires EquipmentCharacterGeneric Edit10 Allow NULL? 
184AIRQ08Requires Reference Number 1CharacterGeneric Edit10 Allow NULL? 
185AIDR08Default Reference Number Qualifier 1StringUDC (41 X6)20 Allow NULL? 
186AIDR09Default Identification Code QualifierStringUDC (41 X6)20 Allow NULL? 
187AIRQ09Requires Reference Number 2CharacterGeneric Edit10 Allow NULL? 
188AIUSERUser IDStringGeneric Edit100 Allow NULL? 
189AIPIDProgram IDStringGeneric Edit100 Allow NULL? 
190AIUPMJDate - UpdatedDateGeneric Edit60
191AIUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
192AIJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
193AIPRGFPurge FlagCharacterGeneric Edit10 Allow NULL? 
194AIBYALBypass Audit LoggingCharacterGeneric Edit10 Allow NULL? 
195AIBSCBuying Segment CodeStringUDC (42B BS)100 Allow NULL? 
196AIASHLAllow Shipping of Held LotsCharacterGeneric Edit10 Allow NULL? 
197AIPRSNPreference ScheduleStringGeneric Edit80 Allow NULL? 
198AIOPBOOP Business ObjectiveStringUDC (34A BO)300 Allow NULL? 
199AIAPSBAPS Business UnitCharacterGeneric Edit10 Allow NULL? 
200AITIER1TierStringUDC (01 TI)50 Allow NULL? 
201AIPWPCPPay When Paid Cash Receipt ThresholdNumericGeneric Edit50 Allow NULL? 
202AICUSTSCustomer StatusCharacterUDC (01 TY)10 Allow NULL? 
203AISTOFOverride Sales Team AssignmentCharacterGeneric Edit10 Allow NULL? 
204AITERRIDTerritory IdNumericGeneric Edit150 Allow NULL? 
205AICIGIndustry GroupNumericGeneric Edit150 Allow NULL? 
206AITORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
207AIDTEEDate - EnteredJDE UTimeGeneric Edit110
208AISYNCSSynchronization StatusNumericUDC (90CA SY)20 Allow NULL? 
209AICAADServer StatusNumericUDC (90CA SE)20 Allow NULL? 
210AIGOPASFGOP Arrival or Ship FlagCharacterUDC (34A AS)10 Allow NULL? 

TOP920 | 03 | F03012 INDEXES

NumberDescription
1ADDRESS_COMPANY (Primary/Unique)
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2COCompanyAscending
2POLICY AN8 CO (Unique)
ElementAliasDescriptionSequence
1PLYPolicy Number (Internal)Ascending
2AN8Address NumberAscending
3COCompanyAscending
3ADDRESS_NO
ElementAliasDescriptionSequence
1AN8Address NumberAscending
4COMPANY ADDRESS
ElementAliasDescriptionSequence
1COCompanyAscending
2AN8Address NumberAscending
5INDUSTRY ADDRESS COMPANY
ElementAliasDescriptionSequence
1CIGIndustry GroupAscending
2AN8Address NumberAscending
3COCompanyAscending
6TERRITORYID ADDRESS COMPANY
ElementAliasDescriptionSequence
1TERRIDTerritory IdAscending
2AN8Address NumberAscending
3COCompanyAscending
7CUSTOMER GROUP CATEGORY CODES
ElementAliasDescriptionSequence
1CPGPCustomer Price GroupAscending
2AC01Category Code - Address Book 01Ascending
3AC02Category Code - Address Book 02Ascending
4AC03Category Code - Address Book 03Ascending
5AC04Category Code - Address Book 04Ascending
6AC05Category Code - Address Book 05Ascending
7AC06Category Code - Address Book 06Ascending
8AC07Category Code - Address Book 07Ascending
9AC08Category Code - Address Book 08Ascending
10AC09Category Code - Address Book 09Ascending
11AC10Category Code - Address Book 10Ascending
12AC11Sales RegionAscending
13AC12Category Code - Address Book 12Ascending
14AC13Category Code - Address Book 13Ascending
15AC14Category Code - Address Book 14Ascending
16AC15Category Code - Address Book 15Ascending