| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | GroupCode | Group No. | int | 6 | 0 | | | | Allow NULL? |
| 2 | GroupName | Group Name | nvarchar | 20 | 0 | | | | Allow NULL? |
| 3 | GroupType | Group Type | char | 1 | 0 | | C | C=Customer Group, S=Vendor Group | Allow NULL? |
| 4 | Locked | Locked | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 5 | 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? |
| 6 | UserSign | User Signature | int | 6 | 0 | | | | Allow NULL? |
| 7 | PriceList | Price List | int | 6 | 0 | | | | Allow NULL? |
| 8 | DiscRel | Effective Discount | char | 1 | 0 | | L | A=Average, H=Highest Discount, L=Lowest Discount, M=Discount Multiples, S=Total | Allow NULL? |