| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | WTM3 | Approval Templates - Documents | 2 | TransType | Original Document | nVarChar | 20 | 0 | | (-=(-, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correction Invoice, 166=A/R Correction Invoice Reversal, 16=Returns, 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 |
| TOPFinance |
| 2 | AJD1 | Journal Entry - History - Rows | 20 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | (-=(-, -1=All Transactions, -2=Opening Balance, -3=Closing Balance, 10000079=TDS Adjustment, 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Valuation, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correct |
| 3 | AJDT | Journal Entry - History | 4 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | (-=(-, -1=All Transactions, -2=Opening Balance, -3=Closing Balance, 10000079=TDS Adjustment, 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Valuation, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correct |
| 4 | BTF1 | Journal Voucher | 20 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | |
| 5 | JDT1 | Journal Entry - Rows | 20 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | (-=(-, -1=All Transactions, -2=Opening Balance, -3=Closing Balance, 10000079=TDS Adjustment, 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Valuation, 163=A/P Correction Invoice, 164=A/P Correction Invoice Reversal, 165=A/R Correct |
| 6 | OBTF | Journal Voucher Entry | 4 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | |
| 7 | OCFT | Cash Flow Transactions - Rows | 14 | TransType | Source Object | nVarChar | 20 | 0 | | 140=Payment Draft, 24=Incoming Payment, 29=Journal Vouchers List, 30=Journal Entry, 46=Vendor Payment |
| 8 | OJDT | Journal Entry | 4 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | (-=(-, -1=All Transactions, -2=Opening Balance, -3=Closing Balance, 10000046=Data Archive, 10000071=Inventory Posting, 10000079=TDS Adjustment, 132=Correction Invoice, 13=A/R Invoice, 140000009=Outgoing Excise Invoice, 140000010=Incoming Excise Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Valuation, 163=A/P Correction Invoice, 1 |
| 9 | SLM1 | Special Ledger - Analytical Accounting Report Lines: Material | 5 | TransType | Transaction Type Number | Int | 6 | 0 | | |
| 10 | SLR1 | Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses | 5 | TransType | Transaction Type Number | Int | 6 | 0 | | |
| TOPInventory and Production |
| 11 | OAIM | Archive Inventory Message | 3 | TransType | Transaction Type | Int | 11 | 0 | -1 | |
| 12 | OILM | Inventory Log Message | 3 | TransType | Transaction Type | Int | 11 | 0 | -1 | |
| 13 | OIMT | Templates for Inventory JE | 2 | TransType | Transaction type | Int | 11 | 0 | -1 | |
| 14 | OINM | Whse Journal | 2 | TransType | Transaction Type | Int | 11 | 0 | -1 | (-=(-, -1=All Transactions, -2=Opening Balance, 10000071=Inventory Posting, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Revaluation, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 20=Goods Receipt, 21=Goods Return, 310000001=Initial Quantity, 58=Stock Update, 59=Goods Receipt, 60=Goods Issue, 67= |
| 15 | OIVL | Whse Journal | 1 | TransType | Transaction Type | Int | 11 | 0 | -1 | (-=(-, -1=All Transactions, -2=Opening Balance, 10000071=Inventory Posting, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Revaluation, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 20=Goods Receipt, 21=Goods Return, 310000001=Initial Quantity, 58=Stock Update, 59=Goods Receipt, 60=Goods Issue, 67= |
| 16 | UILM | IVI Inventory Log Message | 3 | TransType | Transaction Type | Int | 11 | 0 | -1 | |
| 17 | UIVL | Whse Journal | 1 | TransType | Transaction Type | Int | 11 | 0 | -1 | (-=(-, -1=All Transactions, -2=Opening Balance, 132=Correction Invoice, 13=A/R Invoice, 14=A/R Credit Memo, 15=Delivery, 162=Inventory Revaluation, 16=Returns, 18=A/P Invoice, 19=A/P Credit Memo, 20=Goods Receipt, 21=Goods Return, 58=Inventory Update, 59=Goods Receipt, 60=Goods Issue, 67=Inventory Transfer, 68=Work Instructions, 69=Landed |
