| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| TOPAdministration |
| 1 | AWFQ | SWFQ History Table | 5 | TransType | Transaction Type | VarChar | 1 | 0 | | A=Add, C=Cancel, D=Delete, U=Update |
| 2 | WTM3 | Approval Templates - Documents | 2 | TransType | Original Document | nVarChar | 20 | 0 | | (-0=(-, (-1=(-, (-2=(-, (-3=(-, 10000071=Inventory Posting, 1250000001=Inventory Transfer Request, 132=Correction Invoice, 13=A/R Invoice, 1470000065=Inventory Counting, 1470000113=Purchase Request, 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 Correcti |
| TOPFinance |
| 3 | ACD1 | Credit Memo - Rows | 17 | TransType | Transaction Type | nVarChar | 4 | 0 | | 0=Unknown, 110=Acquisition, 115=Subacquisition, 120=Credit Memo, 130=APC Write-Up, 210=Full Retirement, 220=Full Scrapping, 230=Partial Retirement, 240=Partial Scrapping, 310=Full Transfer, 320=Partial Transfer, 410=Manual Ordinary Depreciation, 420=Manual Unplanned Depreciation, 430=Manual Special Depreciation, 440=Appreciation, 510=Chang |
| 4 | ACQ1 | Capitalization - Rows | 17 | TransType | Transaction Type | nVarChar | 4 | 0 | | 0=Unknown, 110=Acquisition, 115=Subacquisition, 120=Credit Memo, 130=APC Write-Up, 210=Full Retirement, 220=Full Scrapping, 230=Partial Retirement, 240=Partial Scrapping, 310=Full Transfer, 320=Partial Transfer, 410=Manual Ordinary Depreciation, 420=Manual Unplanned Depreciation, 430=Manual Special Depreciation, 440=Appreciation, 510=Chang |
| 5 | AFA1 | Asset Document - Rows | 17 | TransType | Transaction Type | nVarChar | 4 | 0 | | 0=Unknown, 110=Acquisition, 115=Subacquisition, 120=Credit Memo, 130=APC Write-Up, 210=Full Retirement, 220=Full Scrapping, 230=Partial Retirement, 240=Partial Scrapping, 310=Full Transfer, 320=Partial Transfer, 410=Manual Ordinary Depreciation, 420=Manual Unplanned Depreciation, 430=Manual Special Depreciation, 440=Appreciation, 510=Chang |
| 6 | AFAD | Asset Document - History | 26 | TransType | Original Document | nVarChar | 20 | 0 | -1 | -1=All Transactions, 13=A/R Invoice, 1470000049=Capitalization, 1470000060=Fixed Assets Credit Memo, 1470000075=Manual Depreciation, 1470000090=Fixed Assets Transfer, 1470000094=Retirement, 163=A/P Correction Invoice, 18=A/P Invoice, 19=A/P Credit Memo, 46=Outgoing Payment |
| 7 | AJD1 | Journal Entry - History - Rows | 20 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | (-0=(-, (-1=(-, (-2=(-, (-3=(-, (-4=(-, (-5=(-, -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 Cor |
| 8 | AJDT | Journal Entry - History | 4 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | (-0=(-, (-1=(-, (-2=(-, (-3=(-, (-4=(-, (-5=(-, (-6=(-, -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, 1470000049=Fixed Asset Capitalization, |
| 9 | BTF1 | Journal Voucher - Rows | 20 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | |
| 10 | FAC1 | Fixed Asset Parameter Change - Rows | 4 | TransType | Transaction Type | nVarChar | 4 | 0 | | 0=Unknown, 510=Change of Depreciation Type, 520=Change of Useful Life, 530=Change of Depreciation Start Date, 540=Change of Salvage Value, 560=Change of Period Control |
| 11 | FIX1 | Fixed Asset Transaction - Rows | 23 | TransType | Transaction Type | nVarChar | 4 | 0 | | 0=Unknown, 110=Acquisition, 115=Subacquisition, 120=Credit Memo, 210=Full Retirement, 220=Full Scrapping, 230=Partial Retirement, 240=Partial Scrapping, 260=Low Value Asset Full Retirement, 270=Low Value Asset Full Scrapping, 310=Full Transfer, 320=Partial Transfer, 330=Asset Class Transfer, 410=Manual Ordinary Depreciation, 420=Manual Unp |
| 12 | FTR1 | Transfer - Rows | 17 | TransType | Transaction Type | nVarChar | 4 | 0 | | 0=Unknown, 110=Acquisition, 115=Subacquisition, 120=Credit Memo, 130=APC Write-Up, 210=Full Retirement, 220=Full Scrapping, 230=Partial Retirement, 240=Partial Scrapping, 310=Full Transfer, 320=Partial Transfer, 410=Manual Ordinary Depreciation, 420=Manual Unplanned Depreciation, 430=Manual Special Depreciation, 440=Appreciation, 510=Chang |
| 13 | JDT1 | Journal Entry - Rows | 20 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | (-0=(-, (-1=(-, (-2=(-, (-3=(-, (-4=(-, (-5=(-, -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 Cor |
| 14 | MDP1 | Manual Depreciation - Rows | 17 | TransType | Transaction Type | nVarChar | 4 | 0 | | 0=Unknown, 110=Acquisition, 115=Subacquisition, 120=Credit Memo, 130=APC Write-Up, 210=Full Retirement, 220=Full Scrapping, 230=Partial Retirement, 240=Partial Scrapping, 310=Full Transfer, 320=Partial Transfer, 410=Manual Ordinary Depreciation, 420=Manual Unplanned Depreciation, 430=Manual Special Depreciation, 440=Appreciation, 510=Chang |
| 15 | OACD | Credit Memo | 26 | TransType | Original Document | nVarChar | 20 | 0 | -1 | -1=All Transactions, 13=A/R Invoice, 1470000049=Capitalization, 1470000060=Fixed Assets Credit Memo, 1470000075=Manual Depreciation, 1470000090=Fixed Assets Transfer, 1470000094=Retirement, 163=A/P Correction Invoice, 18=A/P Invoice, 19=A/P Credit Memo, 46=Outgoing Payment |
| 16 | OACQ | Capitalization | 26 | TransType | Original Document | nVarChar | 20 | 0 | -1 | -1=All Transactions, 13=A/R Invoice, 1470000049=Capitalization, 1470000060=Fixed Assets Credit Memo, 1470000075=Manual Depreciation, 1470000090=Fixed Assets Transfer, 1470000094=Retirement, 163=A/P Correction Invoice, 18=A/P Invoice, 19=A/P Credit Memo, 46=Outgoing Payment |
| 17 | OBTF | Journal Voucher Entry | 4 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | (-0=(-, (-1=(-, (-2=(-, (-3=(-, (-4=(-, (-5=(-, (-6=(-, -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, 1470000049=Fixed Asset Capitalization, |
| 18 | OCFT | Cash Flow Transactions - Rows | 14 | TransType | Source Object | nVarChar | 20 | 0 | | 140=Payment Draft, 157=Payment Wizard, 182=Bill of Exchange Transaction, 24=Incoming Payment, 25=Deposit, 29=Journal Vouchers List, 30=Journal Entry, 42=Bank Statement, 46=Vendor Payment, 76=Postdated Check Deposit |
| 19 | ODRN | Depreciation Run | 16 | TransType | Generate Document | nVarChar | 20 | 0 | -1 | -1=None, 18=A/P Invoice |
| 20 | OFTR | Transfer | 26 | TransType | Original Document | nVarChar | 20 | 0 | -1 | -1=All Transactions, 13=A/R Invoice, 1470000049=Capitalization, 1470000060=Fixed Assets Credit Memo, 1470000075=Manual Depreciation, 1470000090=Fixed Assets Transfer, 1470000094=Retirement, 163=A/P Correction Invoice, 18=A/P Invoice, 19=A/P Credit Memo, 46=Outgoing Payment |
| 21 | OJDT | Journal Entry | 4 | TransType | Original Journal | nVarChar | 20 | 0 | -1 | (-0=(-, (-1=(-, (-2=(-, (-3=(-, (-4=(-, (-5=(-, (-6=(-, -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, 1470000049=Fixed Asset Capitalization, |
| 22 | OMDP | Manual Depreciation | 26 | TransType | Original Document | nVarChar | 20 | 0 | -1 | -1=All Transactions, 13=A/R Invoice, 1470000049=Capitalization, 1470000060=Fixed Assets Credit Memo, 1470000075=Manual Depreciation, 1470000090=Fixed Assets Transfer, 1470000094=Retirement, 163=A/P Correction Invoice, 18=A/P Invoice, 19=A/P Credit Memo, 46=Outgoing Payment |
| 23 | ORTI | Retirement | 26 | TransType | Original Document | nVarChar | 20 | 0 | -1 | -1=All Transactions, 13=A/R Invoice, 1470000049=Capitalization, 1470000060=Fixed Assets Credit Memo, 1470000075=Manual Depreciation, 1470000090=Fixed Assets Transfer, 1470000094=Retirement, 163=A/P Correction Invoice, 18=A/P Invoice, 19=A/P Credit Memo, 46=Outgoing Payment |
| 24 | RTI1 | Retirement - Rows | 17 | TransType | Transaction Type | nVarChar | 4 | 0 | | 0=Unknown, 110=Acquisition, 115=Subacquisition, 120=Credit Memo, 130=APC Write-Up, 210=Full Retirement, 220=Full Scrapping, 230=Partial Retirement, 240=Partial Scrapping, 310=Full Transfer, 320=Partial Transfer, 410=Manual Ordinary Depreciation, 420=Manual Unplanned Depreciation, 430=Manual Special Depreciation, 440=Appreciation, 510=Chang |
| 25 | SLM1 | Special Ledger - Analytical Accounting Report Lines: Material | 5 | TransType | Transaction Type Number | Int | 6 | 0 | | |
| 26 | SLR1 | Special Ledger - Analytical Accounting Report Lines: Revenues & Expenses | 5 | TransType | Transaction Type Number | Int | 6 | 0 | | |
| TOPGeneral |
| 27 | SEVT | SEVT | 7 | TransType | Transaction type | VarChar | 1 | 0 | | |
| 28 | SEWUT | SEWUT | 3 | transtype | transtype | nVarChar | 3 | 0 | | |
| 29 | SWFQ | SWFQ | 5 | TransType | Transaction Type | VarChar | 1 | 0 | | A=Add, C=Cancel, D=Delete, U=Update |
| TOPInventory and Production |
| 30 | OAIM | Archive Inventory Message | 3 | TransType | Transaction Type | Int | 11 | 0 | -1 | |
| 31 | OILM | Inventory Log Message | 3 | TransType | Transaction Type | Int | 11 | 0 | -1 | |
| 32 | OIMT | Templates for Inventory JE | 2 | TransType | Transaction type | Int | 11 | 0 | -1 | |
| 33 | OIVL | Whse Journal | 1 | TransType | Transaction Type | Int | 11 | 0 | -1 | (-0=(-, (-1=(-, (-2=(-, -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=Inventory Update, 59=Goods Receipt |
| 34 | SIVL | Whse Journal | 1 | TransType | Transaction Type | Int | 11 | 0 | -1 | (-0=(-, (-1=(-, (-2=(-, -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 Instruc |
| 35 | UILM | IVI Inventory Log Message | 3 | TransType | Transaction Type | Int | 11 | 0 | -1 | |
| 36 | UIVL | Whse Journal | 1 | TransType | Transaction Type | Int | 11 | 0 | -1 | (-0=(-, (-1=(-, (-2=(-, -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 Instruc |
