| 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 | OUSR | | | Allow NULL? |
| 7 | PriceList | Price List | int | 6 | 0 | OPLN | | | Allow NULL? |
| 8 | DiscRel | Effective Discount Groups | char | 1 | 0 | | L | A=Average, H=Highest Discount, L=Lowest Discount, M=Discount Multiples, S=Total | Allow NULL? |
| 9 | EffecPrice | Effective Price | char | 1 | 0 | | D | D=Default Priority, H=Highest Price, L=Lowest Price | Allow NULL? |
