| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPAdministration |
1 | WTM4 | Approval Templates - Terms | 3 | opCode | Ratio | Int | 6 | 0 | 0 | 0=Undefined Type, 1=Greater Than, 2=Greater or Equal, 3=Less Than, 4=Less or Equal, 5=Equal, 6=Does not Equal, 7=In Range, 8=Not in Range |
TOPFinance |
2 | AVTG | Tax Definition | 48 | OpCode | Tax Operation Code | nVarChar | 7 | 0 | | |
3 | OVTG | Tax Definition | 48 | OpCode | Tax Operation Code | nVarChar | 7 | 0 | | |
TOPMarketing Documents |
4 | ATX2 | Tax Invoice Operation Codes | 3 | OpCode | Operation Code | Int | 11 | 0 | | |
5 | TPI2 | Tax Invoice Operation Codes | 3 | OpCode | Operation Code | Int | 11 | 0 | | |
6 | TSI2 | Tax Invoice Operation Codes | 3 | OpCode | Operation Code | Int | 11 | 0 | | |
7 | TXD2 | Tax Invoice Draft Operation Codes | 3 | OpCode | Operation Code | Int | 11 | 0 | | |
8 | WDD2 | Documents for Approval - Terms | 3 | opCode | Ratio | Int | 6 | 0 | | 1=Greater than, 2=Greater or Equal, 3=Less than, 4=Less or Equal, 5=Equal, 6=Does not Equal |