| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPInventory and Production |
1 | WTC2 | WTax Certificates - Docs in WT Groups | 5 | DocObjType | Doc. Object Type | nVarChar | 20 | 0 | | |
TOPMarketing Documents |
2 | ATR1 | Transportation Document Lines - History | 3 | DocObjType | Document Object Type | Int | 11 | 0 | | 13=A/R Invoice, 15=Delivery, 21=Goods Return, 67=Inventory Transfer |
3 | ORCL | Recurring Transaction Instances | 6 | DocObjType | Document Object Type | nVarChar | 20 | 0 | | 112=Draft, 13=Invoice |
4 | ORCP | Recurring Transaction Template | 5 | DocObjType | Linked Document Type | nVarChar | 20 | 0 | -1 | -13=A/R Reserve Invoice, -18=A/P Reserve Invoice, -203=A/R Down Payment Request, -204=A/P Down Payment Request, 1250000001=Inventory Transfer Request, 13=A/R Invoice, 1470000113=Purchase Request, 14=A/R Credit Memo, 15=Delivery, 16=Return, 17=Sales Order, 18=A/P Invoice, 19=A/P Credit Memo, 203=A/R Down Payment Invoice, 204=A/P Down Paymen |
5 | TRO1 | Lines of Transportation Document | 3 | DocObjType | Document Object Type | Int | 11 | 0 | | 13=A/R Invoice, 15=Delivery, 21=Goods Return, 67=Inventory Transfer |