| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | GroupNum | Group Number | int | 6 | 0 | | | | Allow NULL? |
| 2 | PymntGroup | Payment Terms Code | nvarchar | 100 | 0 | | | | Allow NULL? |
| 3 | PayDuMonth | Start From | char | 1 | 0 | | N | E=Month End, H=Half Month, N, Y=Month Start | Allow NULL? |
| 4 | ExtraMonth | Number of Additional Months | int | 6 | 0 | | 0 | | Allow NULL? |
| 5 | ExtraDays | Number of Additional Days | int | 6 | 0 | | 0 | | Allow NULL? |
| 6 | PaymntsNum | Number of Payments | int | 6 | 0 | | | | Allow NULL? |
| 7 | CredLimit | Max. Credit | num | 19 | 6 | | | | Allow NULL? |
| 8 | VolumDscnt | Total Discount % | num | 19 | 6 | | | | Allow NULL? |
| 9 | LatePyChrg | Interest % on Receivables | num | 19 | 6 | | | | Allow NULL? |
| 10 | ObligLimit | Commitment Limit | num | 19 | 6 | | | | Allow NULL? |
| 11 | ListNum | Price List | int | 6 | 0 | OPLN | | | Allow NULL? |
| 12 | Payments | Partial Payment | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 13 | NumOfPmnts | Number of Payments | int | 6 | 0 | | 1 | | Allow NULL? |
| 14 | Payment1 | First Partial Payment | num | 19 | 6 | | | | Allow NULL? |
| 15 | 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? |
| 16 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 17 | OpenRcpt | Open Incoming Payment | char | 1 | 0 | | N | 1=Checks, 2=Bank Transfer, 3=Cash, 4=Credit, 5=Bill of Exchange, N=No | Allow NULL? |
| 18 | DiscCode | Discount Code | nvarchar | 20 | 0 | OCDC | | | Allow NULL? |
| 19 | DunningCod | Dunning Code | nvarchar | 20 | 0 | ORIT | | | Allow NULL? |
| 20 | BslineDate | Due Date Based on | char | 1 | 0 | | T | C=Closing Date, P=Posting Date, S=System Date, T=Document Date | Allow NULL? |
| 21 | InstNum | No. of Installments | int | 6 | 0 | | | | Allow NULL? |
| 22 | TolDays | No. of Tolerance Days | int | 6 | 0 | | | | Allow NULL? |
| 23 | VATFirst | Apply Tax on 1st Installment | char | 1 | 0 | | N | N=No, T=Tax Only, Y=Yes | Allow NULL? |
| 24 | CrdMthd | Credit Method | char | 1 | 0 | | L | E=Equally, F=First Installment, L=Last Installment | Allow NULL? |
| 25 | CshRelev | Cash Relevant Transaction | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
