| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | TrnsCode | Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 2 | TrnsCodDsc | Description | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | Locked | Locked | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 4 | 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? |
| 5 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 6 | Pcn874Ctg | Trans. Category for PCN874 | char | 1 | 0 | | N | C=Self-Employed - Purchase, E=Export Log, I=Import Log, M=Self-Employed - Sales, N=None, O=Other, P=A/P Invoice - Palestine, R=A/R Invoice - Palestine | Allow NULL? |
