| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsEntry | Unique Entry | int | 11 | 0 | | | | Allow NULL? |
| 2 | Type | Type | char | 1 | 0 | | | A=All BPs, C=Customer Group, S=Specific BP, V=Vendor Group | Allow NULL? |
| 3 | ObjType | Object Type | nvarchar | 20 | 0 | | -1 | -1, 10=Card Payment Groups, 2=Cards | Allow NULL? |
| 4 | ObjCode | Object Code | nvarchar | 15 | 0 | | | | Allow NULL? |
| 5 | DiscRel | Disc. Relations | char | 1 | 0 | | L | A=Average, H=Highest Discount, L=Lowest Discount, M=Discount Multiples, S=Total | Allow NULL? |
| 6 | ValidFor | Active | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 7 | ValidForm | Active From | date | 8 | 0 | | | | |
| 8 | ValidTo | Active To | date | 8 | 0 | | | | |
| 9 | 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? |
| 10 | UserSign | User Form | int | 6 | 0 | OUSR | | | Allow NULL? |
| 11 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 12 | UserSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 13 | CreateDate | Creation Date | date | 8 | 0 | | | | |
| 14 | UpdateDate | Update Date | date | 8 | 0 | | | | |
