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

211 COLUMNS | 13 INDEXES | Print definition?812 | 17C | F1755 TABLE

17C: Call Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F1755ZA21113Customer Call MasterMaster Files17C: Call ManagementNo
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 ZASTAW, ZADOCO, ZAUPMJ, ZAUPMT, ZADCTO, ZAKCOO, ZACT01, ZACT02, ZAPRIOR, ZACLST, ZADESC, ZAISSUE, ZASERK, ZASCALL, ZAVRU, ZACALLRN, ZATASKNO, ZATIMEZONES, ZADSAVNAME, ZAREGION, ZALNGP, ZAPARCALL, ZACALLQ, ZAAN8, ZAPH1, ZAANC, ZAIDLN, ZAAR1, ZACPH, ZAWHO1, ZAREM1, ZAFAR1, ZACFAX1, ZAAAR1, ZAPHN1, ZACTR, ZAAN8CT1, ZAIDLNC1, ZAAR2, ZACPHC1, ZAWHO2, ZACEML1, ZAFAR2, ZACFAX2, ZAAAR2, ZAPHN2, ZAAN8CT2, ZAIDLNC2, ZAAR3, ZACPHC2, ZAWHO3, ZACEML2, ZAFAR3, ZACFAX3, ZAAAR3, ZAPHN3, ZAAN8CT3, ZAIDLNC3, ZAAR4, ZACPHC3, ZAWHO4, ZACEML3, ZAFAR4, ZACFAX4, ZAAAR4, ZAPHN4, ZANUMB, ZAPRODF, ZAPRODM, ZAPRODC, ZAITM, ZAMMCU, ZALOTN, ZAENV, ZALANO, ZADOCZ, ZARCTO, ZARKCO, ZARLIN, ZACOCH, ZAOORN, ZAOCTO, ZAOKCO, ZADOC, ZADCT, ZAKCO, ZADOCM, ZADCTM, ZAKCOP, ZAENTCK, ZAGWAUT, ZABILL, ZAMTHPR, ZAGLCCV, ZAGLCNC, ZACOST, ZALNTY, ZARSTM, ZAHMCU, ZAOBJ, ZASUB, ZACSCL, ZAISNO, ZAAG, ZAACR, ZAMODE, ZACRCD, ZACRDC, ZAHRSO, ZAAMTO, ZAFAP, ZADTBIL, ZAASN3, ZACOVGR, ZAMCUZ, ZACO, ZAPBTM, ZAEFTB, ZAPETM, ZAEND, ZADX, ZAINRT, ZAONSDT, ZAONSTM, ZADRQJ, ZADRQT, ZASESD, ZASEED, ZASEST, ZASEET, ZADEF, ZADL01, ZATELH, ZAEDAYS, ZAIDYS, ZACOMD, ZACDATE, ZACTIME, ZAESC1, ZAESC2, ZAESDTE, ZAESTME, ZAJC01, ZAJC02, ZAJC03, ZAJC04, ZAJC05, ZAJC06, ZAJC07, ZAJC08, ZAJC09, ZAJC10, ZAZE01, ZAZE02, ZAZE03, ZAZE04, ZAZE05, ZAZE06, ZAZE07, ZAZE08, ZAZE09, ZAZE10, ZAURAB, ZAURCD, ZAURAT, ZAURDT, ZAURRF, ZAEFFT, ZACRTU, ZAUSER, ZAPID, ZAJOBN, ZATYPS, ZACRRM, ZACRR, ZAPEFJ, ZABLCN, ZAUM, ZAAMTFD, ZAAMTFF, ZAPCOVR, ZAGWAFL, ZAGWANC, ZASERP, ZAANOB, ZAUSA5, ZAVR01, ZAMINHR, ZAMINAD, ZAMINAF, ZADSFT, ZADSPC, ZAIDSC, ZACIDS, ZAITAM, ZACITX, ZAJTAX, ZAJTXF, ZAAMTCD, ZAAMTCF, ZAATXCD, ZAATXCF, ZAEFTJ, ZAPTC, ZARYIN, ZATAX1, ZATXA1, ZAPRAN8, ZAPRCNCT, ZAPRCIDLN, ZAEXR1 FROM F1755

TOP812 | 17C | F1755 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ZASTAWStatusCharacterUDC (00 WS)10 Allow NULL? 
2ZADOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3ZAUPMJDate - UpdatedDateGeneric Edit60
4ZAUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
5ZADCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
6ZAKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
7ZACT01Case Type - 1CharacterUDC (17 CT)10 Allow NULL? 
8ZACT02Case Type - 2CharacterUDC (17 SC)10 Allow NULL? 
9ZAPRIORIssue PriorityStringUDC (17 PR)20 Allow NULL? 
10ZACLSTCase Status CodeStringUDC (17 ST)30 Allow NULL? 
11ZADESCDescriptionStringGeneric Edit300 Allow NULL? 
12ZAISSUEProblem DescriptionStringGeneric Edit800 Allow NULL? 
13ZASERKKey Value Serial NumberNumericGeneric Edit150 Allow NULL? 
14ZASCALLCall BacksCharacterUDC (17 CB)10 Allow NULL? 
15ZAVRUVoice Response Unit SessionStringGeneric Edit200 Allow NULL? 
16ZACALLRNCase ReasonStringUDC (17 CR)30 Allow NULL? 
17ZATASKNONumber of Open TasksNumericGeneric Edit80 Allow NULL? 
18ZATIMEZONESTime Zone ListStringUDC (H91 TZ)20 Allow NULL? 
19ZADSAVNAMEDaylight Savings Rule NameStringUDC100 Allow NULL? 
20ZAREGIONGeographic Region CodeStringUDC (17 GR)30 Allow NULL? 
21ZALNGPLanguageStringUDC (01 LP)20 Allow NULL? 
22ZAPARCALLDocument- Parent CaseNumericGeneric Edit80 Allow NULL? 
23ZACALLQCase Provider GroupNumericGeneric Edit80 Allow NULL? 
24ZAAN8Address NumberNumericUDC80 Allow NULL? 
25ZAPH1Phone NumberStringGeneric Edit200 Allow NULL? 
26ZAANCAddress Number - Customer NumberNumericGeneric Edit80 Allow NULL? 
27ZAIDLNWho's Who Line Number - IDNumericGeneric Edit50 Allow NULL? 
28ZAAR1Phone PrefixStringGeneric Edit60 Allow NULL? 
29ZACPHcall from phoneStringGeneric Edit200 Allow NULL? 
30ZAWHO1Contact Name 1StringGeneric Edit400 Allow NULL? 
31ZAREM1Remark 1StringGeneric Edit400 Allow NULL? 
32ZAFAR1FAX PrefixStringGeneric Edit60 Allow NULL? 
33ZACFAX1Case Fax Number 1StringGeneric Edit200 Allow NULL? 
34ZAAAR1Alt Phone Prefix 1StringGeneric Edit60 Allow NULL? 
35ZAPHN1Phone NumberStringGeneric Edit200 Allow NULL? 
36ZACTRCountryStringUDC (00 CN)30 Allow NULL? 
37ZAAN8CT1Contact1 Address NumberNumericGeneric Edit80 Allow NULL? 
38ZAIDLNC1Who's Who Line Number Contact 1NumericGeneric Edit50 Allow NULL? 
39ZAAR2Phone Prefix 2StringGeneric Edit60 Allow NULL? 
40ZACPHC1Case From Phone Contact 1StringGeneric Edit200 Allow NULL? 
41ZAWHO2Contact Name 2StringGeneric Edit400 Allow NULL? 
42ZACEML1Case E-Mail Address 1StringGeneric Edit400 Allow NULL? 
43ZAFAR2FAX Prefix 2StringGeneric Edit60 Allow NULL? 
44ZACFAX2Case Fax Number 2StringGeneric Edit200 Allow NULL? 
45ZAAAR2Alt Phone Prefix 2StringGeneric Edit60 Allow NULL? 
46ZAPHN2Phone NumberStringGeneric Edit200 Allow NULL? 
47ZAAN8CT2Contact2 Address NumberNumericGeneric Edit80 Allow NULL? 
48ZAIDLNC2Who's Who Line Number Contact 2NumericGeneric Edit50 Allow NULL? 
49ZAAR3Phone Area Code 3StringGeneric Edit60 Allow NULL? 
50ZACPHC2Case From Phone Contact 2StringGeneric Edit200 Allow NULL? 
51ZAWHO3Contact Name 3StringGeneric Edit400 Allow NULL? 
52ZACEML2Case E-Mail Address 2StringGeneric Edit400 Allow NULL? 
53ZAFAR3FAX Prefix 3StringGeneric Edit60 Allow NULL? 
54ZACFAX3Case Fax Number 3StringGeneric Edit200 Allow NULL? 
55ZAAAR3Alt Phone Prefix 3StringGeneric Edit60 Allow NULL? 
56ZAPHN3Phone NumberStringGeneric Edit200 Allow NULL? 
57ZAAN8CT3Contact3 Address NumberNumericGeneric Edit80 Allow NULL? 
58ZAIDLNC3Who's Who Line Number Contact 3NumericGeneric Edit50 Allow NULL? 
59ZAAR4Phone Area Code 4StringGeneric Edit60 Allow NULL? 
60ZACPHC3Case From Phone Contact 3StringGeneric Edit200 Allow NULL? 
61ZAWHO4Contact Name 4StringGeneric Edit400 Allow NULL? 
62ZACEML3Case E-Mail Address 3StringGeneric Edit400 Allow NULL? 
63ZAFAR4FAX Prefix 4StringGeneric Edit60 Allow NULL? 
64ZACFAX4Case Fax Number 4StringGeneric Edit200 Allow NULL? 
65ZAAAR4Alt Phone Prefix 4StringGeneric Edit60 Allow NULL? 
66ZAPHN4Phone NumberStringGeneric Edit200 Allow NULL? 
67ZANUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
68ZAPRODFProduct FamilyStringUDC (17 PA)80 Allow NULL? 
69ZAPRODMProduct ModelStringUDC (17 PM)80 Allow NULL? 
70ZAPRODCProduct ComponentStringUDC (17 PC)100 Allow NULL? 
71ZAITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
72ZAMMCUBranchStringGeneric Edit120 Allow NULL? 
73ZALOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
74ZAENVEnvironmentStringUDC (17 EN)100 Allow NULL? 
75ZALANOAddress Number - Lessor/Rentor/MortgagorNumericGeneric Edit80 Allow NULL? 
76ZADOCZDocument (Order # Invoice etc.)NumericGeneric Edit80 Allow NULL? 
77ZARCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
78ZARKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
79ZARLINRelated Payment Line IDNumericGeneric Edit50 Allow NULL? 
80ZACOCHContract Change NumberStringGeneric Edit30 Allow NULL? 
81ZAOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
82ZAOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
83ZAOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
84ZADOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
85ZADCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
86ZAKCODocument CompanyStringGeneric Edit50 Allow NULL? 
87ZADOCMDocument - Matching(Payment or Item)NumericGeneric Edit80 Allow NULL? 
88ZADCTMDocument Type - MatchingStringUDC (00 DT)20 Allow NULL? 
89ZAKCOPDocument Company (A/P Model Document)StringGeneric Edit50 Allow NULL? 
90ZAENTCKEntitlement CheckStringUDC (17 ER)30 Allow NULL? 
91ZAGWAUTGoodwill AuthorizationStringUDC (41 9)40 Allow NULL? 
92ZABILLBillable (Y/N)CharacterUDC (H00 BI)10 Allow NULL? 
93ZAMTHPRMethod of PricingCharacterUDC (17 MP)10 Allow NULL? 
94ZAGLCCVCategory - G/L CoveredStringUDC (41 9)40 Allow NULL? 
95ZAGLCNCCategory - G/L Non-CoveredStringUDC (41 9)40 Allow NULL? 
96ZACOSTCost ComponentStringUDC (30 CA)30 Allow NULL? 
97ZALNTYLine TypeStringGeneric Edit20 Allow NULL? 
98ZARSTMTime - Guaranteed ResponseNumericGeneric Edit52 Allow NULL? 
99ZAHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
100ZAOBJObject AccountStringGeneric Edit60 Allow NULL? 
101ZASUBSubsidiaryStringGeneric Edit80 Allow NULL? 
102ZACSCLService/Warranty Claim NumberStringGeneric Edit200 Allow NULL? 
103ZAISNOIssue NumberNumericGeneric Edit80 Allow NULL? 
104ZAAGAmount - GrossNumericGeneric Edit152 Allow NULL? 
105ZAACRAmount - CurrencyNumericGeneric Edit152 Allow NULL? 
106ZAMODEMode - ProcessingCharacterGeneric Edit10 Allow NULL? 
107ZACRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
108ZACRDCCurrency Code - ToStringGeneric Edit30 Allow NULL? 
109ZAHRSOHours - EstimatedNumericGeneric Edit152 Allow NULL? 
110ZAAMTOAmount - EstimatedNumericGeneric Edit152 Allow NULL? 
111ZAFAPAmount - Foreign OpenNumericGeneric Edit152 Allow NULL? 
112ZADTBILDate - BilledDateGeneric Edit60
113ZAASN3Price and Adjustment Schedule-CasesStringUDC (40 AS)80 Allow NULL? 
114ZACOVGRCoverage GroupStringUDC (17 CG)80 Allow NULL? 
115ZAMCUZBusiness Unit - AltStringGeneric Edit120 Allow NULL? 
116ZACOCompanyStringGeneric Edit50 Allow NULL? 
117ZAPBTMTime - Beginning (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
118ZAEFTBDate - Beginning EffectiveDateGeneric Edit60
119ZAPETMTime - Ending (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
120ZAENDDate - EndingDateGeneric Edit60
121ZADXDate - ExecutionDateGeneric Edit60
122ZAINRTInitial ReturnNumericGeneric Edit60 Allow NULL? 
123ZAONSDTDate - On SiteDateGeneric Edit60
124ZAONSTMTime - ON Site (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
125ZADRQJDate - RequestedDateGeneric Edit60
126ZADRQTRequested Delivery TimeNumericGeneric Edit60 Allow NULL? 
127ZASESDDate - Scheduled Start (Julian)DateGeneric Edit60
128ZASEEDDate - Scheduled End (Julian)DateGeneric Edit60
129ZASESTTime - Scheduled Start (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
130ZASEETTime - Scheduled End (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
131ZADEFDate - EffectiveDateGeneric Edit60
132ZADL01DescriptionStringGeneric Edit300 Allow NULL? 
133ZATELHTime - Total Elapsed HoursNumericGeneric Edit62 Allow NULL? 
134ZAEDAYSElapsed daysNumericGeneric Edit30 Allow NULL? 
135ZAIDYSInitial daysNumericGeneric Edit30 Allow NULL? 
136ZACOMDCommit DurationNumericGeneric Edit60 Allow NULL? 
137ZACDATEDate - CommitmentDateGeneric Edit60
138ZACTIMECommit TimeNumericGeneric Edit60 Allow NULL? 
139ZAESC1Escalation Status 1CharacterGeneric Edit10 Allow NULL? 
140ZAESC2Escalation Status 2CharacterGeneric Edit10 Allow NULL? 
141ZAESDTEDate - EscalationDateGeneric Edit60
142ZAESTMETime - Escalation(HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
143ZAJC01Category Code - Case 01StringUDC (17 01)30 Allow NULL? 
144ZAJC02Category Code - Case 02StringUDC (17 02)30 Allow NULL? 
145ZAJC03Category Code - Case 03StringUDC (17 03)30 Allow NULL? 
146ZAJC04Category Code - Case 04StringUDC (17 04)30 Allow NULL? 
147ZAJC05Category Code - Case 05StringUDC (17 05)30 Allow NULL? 
148ZAJC06Category Code - Case 06StringUDC (17 06)30 Allow NULL? 
149ZAJC07Category Code - Case 07StringUDC (17 07)30 Allow NULL? 
150ZAJC08Category Code - Case 08StringUDC (17 08)30 Allow NULL? 
151ZAJC09Category Code - Case 09StringUDC (17 09)30 Allow NULL? 
152ZAJC10Category Code - Case 10StringUDC (17 10)30 Allow NULL? 
153ZAZE01Category Code - Equipment 01StringUDC (17 B1)100 Allow NULL? 
154ZAZE02Category Code - Equipment 02StringUDC (17 B2)100 Allow NULL? 
155ZAZE03Category Code - Equipment 03StringUDC (17 B3)100 Allow NULL? 
156ZAZE04Category Code - Equipment 04StringUDC (17 B4)100 Allow NULL? 
157ZAZE05Category Code - Equipment 05StringUDC (17 B5)100 Allow NULL? 
158ZAZE06Category Code - Equipment 06StringUDC (17 B6)100 Allow NULL? 
159ZAZE07Category Code - Equipment 07StringUDC (17 B7)100 Allow NULL? 
160ZAZE08Category Code - Equipment 08StringUDC (17 B8)100 Allow NULL? 
161ZAZE09Category Code - Equipment 09StringUDC (17 B9)100 Allow NULL? 
162ZAZE10Category Code - Equipment 10StringUDC (17 B0)100 Allow NULL? 
163ZAURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
164ZAURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
165ZAURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
166ZAURDTUser Reserved DateDateGeneric Edit60
167ZAURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
168ZAEFFTEffective - Thru DateDateGeneric Edit60
169ZACRTUCreated by userStringGeneric Edit100 Allow NULL? 
170ZAUSERUser IDStringGeneric Edit100 Allow NULL? 
171ZAPIDProgram IDStringGeneric Edit100 Allow NULL? 
172ZAJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
173ZATYPSType - W.O.CharacterUDC (00 TY)10 Allow NULL? 
174ZACRRMCurrency Mode-Foreign or Domestic EntryCharacterUDC (H00 CY)10 Allow NULL? 
175ZACRRCurrency Conversion Rate - Spot RateNumericGeneric Edit150 Allow NULL? 
176ZAPEFJDate - Price Effective DateDateGeneric Edit60
177ZABLCNBillable UnitsNumericGeneric Edit154 Allow NULL? 
178ZAUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
179ZAAMTFDDomestic Flat Rate AmountNumericGeneric Edit152 Allow NULL? 
180ZAAMTFFForeign Flat Rate AmountNumericGeneric Edit152 Allow NULL? 
181ZAPCOVRPercent CoveredNumericGeneric Edit52 Allow NULL? 
182ZAGWAFLGoodwill Authorization Code FlagCharacterUDC (17 YN)10 Allow NULL? 
183ZAGWANCNon-Covered Goodwill Authorization CodeStringUDC (41 9)40 Allow NULL? 
184ZASERPService PackageStringGeneric Edit80 Allow NULL? 
185ZAANOBAddress Number - Owner BillingNumericGeneric Edit80 Allow NULL? 
186ZAUSA5Address Number - Send ToNumericGeneric Edit80 Allow NULL? 
187ZAVR01ReferenceStringGeneric Edit250 Allow NULL? 
188ZAMINHRMinimum HoursNumericGeneric Edit92 Allow NULL? 
189ZAMINADMinimum Domestic AmountNumericGeneric Edit152 Allow NULL? 
190ZAMINAFMinimum Foreign AmountNumericGeneric Edit152 Allow NULL? 
191ZADSFTDiscount Factor Type - $ or % (D/P)CharacterUDC (H41 DS)10 Allow NULL? 
192ZADSPCDiscount PercentNumericGeneric Edit83 Allow NULL? 
193ZAIDSCAmount - Invoice Discount AvailableNumericGeneric Edit152 Allow NULL? 
194ZACIDSAmount - Foreign Invoice Discount AvailNumericGeneric Edit152 Allow NULL? 
195ZAITAMAmount - Invoice TaxNumericGeneric Edit152 Allow NULL? 
196ZACITXAmount - Foreign Invoice TaxNumericGeneric Edit152 Allow NULL? 
197ZAJTAXAmount - Journaled TaxNumericGeneric Edit152 Allow NULL? 
198ZAJTXFAmount - Journaled Tax - ForeignNumericGeneric Edit152 Allow NULL? 
199ZAAMTCDDomestic Credit AmountNumericGeneric Edit152 Allow NULL? 
200ZAAMTCFForeign Credit AmountNumericGeneric Edit152 Allow NULL? 
201ZAATXCDDomestic Credit Tax AmountNumericGeneric Edit152 Allow NULL? 
202ZAATXCFForeign Credit Tax AmountNumericGeneric Edit152 Allow NULL? 
203ZAEFTJDate - EffectiveDateGeneric Edit60
204ZAPTCPayment Terms CodeStringGeneric Edit30 Allow NULL? 
205ZARYINPayment InstrumentCharacterUDC (00 PY)10 Allow NULL? 
206ZATAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
207ZATXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
208ZAPRAN8Partner Address NumberNumericGeneric Edit80 Allow NULL? 
209ZAPRCNCTPartner ContactVariable StringGeneric Edit500 Allow NULL? 
210ZAPRCIDLNPartner Contact Line Number IDNumericGeneric Edit50 Allow NULL? 
211ZAEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 

TOP812 | 17C | F1755 INDEXES

NumberDescription
1Call Number Status+ (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2STAWStatusAscending
3UPMJDate - UpdatedAscending
4UPMTTime - Last UpdatedAscending
3Call Type Issue Priority
ElementAliasDescriptionSequence
1CT01Case Type - 1Ascending
2PRIORIssue PriorityAscending
3UPMJDate - UpdatedAscending
4Call Type Status Code
ElementAliasDescriptionSequence
1CT01Case Type - 1Ascending
2CLSTCase Status CodeAscending
5Customer
ElementAliasDescriptionSequence
1ANCAddress Number - Customer NumberAscending
6Product Family Product Model
ElementAliasDescriptionSequence
1PRODFProduct FamilyAscending
2PRODMProduct ModelAscending
7Message ID
ElementAliasDescriptionSequence
1SERKKey Value Serial NumberAscending
8Equipment
ElementAliasDescriptionSequence
1NUMBAsset Item NumberAscending
9Item Number
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
10Call Number Document Type+
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
11Call Number Approval Status
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2STAWStatusAscending
14Address Number Status+
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2STAWStatusAscending
3CLSTCase Status CodeAscending
4SCALLCall BacksDescending
5DOCODocument (Order No Invoice etc.)Descending
6PRIORIssue PriorityDescending
15Call Queue Status+
ElementAliasDescriptionSequence
1CALLQCase Provider GroupAscending
2STAWStatusAscending
3EFTBDate - Beginning EffectiveAscending
4SCALLCall BacksDescending
5DOCODocument (Order No Invoice etc.)Descending
6PRIORIssue PriorityDescending
16Customer Number Status+
ElementAliasDescriptionSequence
1ANCAddress Number - Customer NumberAscending
2STAWStatusAscending
3SCALLCall BacksDescending
4DOCODocument (Order No Invoice etc.)Descending
5PRIORIssue PriorityDescending