| 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 | ORCL | Recurring Transaction Instances | 6 | DocObjType | Document Object Type | nVarChar | 20 | 0 | | 112=Draft, 13=Invoice |
3 | ORCP | Recurring Transaction Template | 5 | DocObjType | Linked Document Type | nVarChar | 20 | 0 | -1 | (-0=(-, (-1=(-, -13=A/R Reserve Invoice, -18=A/P Reserve Invoice, 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, 204=A/P Down Payment, 20=Goods Receipt PO, 21=Goods Return, 22=Purchase O |