| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | AlcCode | Code | nvarchar | 2 | 0 | | | | Allow NULL? |
| 2 | AlcName | Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 3 | OhType | Allocation By | char | 1 | 0 | | F | A=Equal, C=Cash Value After Customs, F=Cash Value Before Customs, Q=Quantity, V=Volume, W=Weight | Allow NULL? |
| 4 | AcctCode | Account Code | nvarchar | 15 | 0 | OACT | | | Allow NULL? |
| 5 | DataSource | Data Source | char | 1 | 0 | | N | A=Doc. Generation Wizard, D=Data Doc., I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year Transfer, U=Update | Allow NULL? |
| 6 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 7 | LaCAllcAcc | Landed Costs Alloc. Account | nvarchar | 15 | 0 | | | | Allow NULL? |