| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | Numerator | Internal Number | int | 11 | 0 | | | | Allow NULL? |
| 2 | CardCode | BP Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 3 | TrcCode | Hierarchy Code | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | TrcName | Hierarchy Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 5 | DateFrom | Valid From | date | 8 | 0 | | | | |
| 6 | DateTo | Valid Until | date | 8 | 0 | | | | |
| 7 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 8 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 9 | LastUpdate | Last Update Date | date | 8 | 0 | | | | |
| 10 | WHShaamGrp | Withholding Shaam Group | char | 1 | 0 | | 1 | 1=Services and Asset, 2=Agricultural Products, 3=Insurance Commissions, 4=Withholding Tax Instructions, 5=Interest, Exchange Rate Differences | Allow NULL? |
| 11 | DdctPrcnt | Deduction % | num | 19 | 6 | | | | Allow NULL? |
| 12 | MaxSum | Maximum Total | num | 19 | 6 | | | | Allow NULL? |