|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Payment Terms
Table Name: OCTG
Table Description: Payment Terms
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| GroupNum | Group Number | Int | 6 | - | Â | Â | Â |
| PymntGroup | Payment Terms Code | nVarChar | 100 | - | Â | Â | Â |
| PayDuMonth | Start From | VarChar | 1 | - | N | E | Month End |
| Â | Â | Â | Â | Â | Â | H | Half Month |
| Â | Â | Â | Â | Â | Â | Y | Month Start |
| Â | Â | Â | Â | Â | Â | N | Selected Date |
| ExtraMonth | Number of Additional Months | Int | 6 | - | 0 | Â | Â |
| ExtraDays | Number of Additional Days | Int | 6 | - | 0 | Â | Â |
| PaymntsNum | Number of Payments | Int | 6 | - | Â | Â | Â |
| CredLimit | Max. Credit | Num | 19.6 | - | Â | Â | Â |
| VolumDscnt | Total Discount % | Num | 19.6 | - | Â | Â | Â |
| LatePyChrg | Interest % on Receivables | Num | 19.6 | - | Â | Â | Â |
| ObligLimit | Commitment Limit | Num | 19.6 | - | Â | Â | Â |
| ListNum | Price List | Int | 6 | OPLN | Â | Â | Â |
| Payments | Partial Payment | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| NumOfPmnts | Number of Payments | Int | 6 | - | 1 | Â | Â |
| Payment1 | First Partial Payment | Num | 19.6 | - | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| OpenRcpt | Open Incoming Payment | VarChar | 1 | - | N | N | No |
| Â | Â | Â | Â | Â | Â | 3 | Cash |
| Â | Â | Â | Â | Â | Â | 1 | Checks |
| Â | Â | Â | Â | Â | Â | 4 | Credit |
| Â | Â | Â | Â | Â | Â | 2 | Bank Transfer |
| Â | Â | Â | Â | Â | Â | 5 | Bill of Exchange |
| DiscCode | Discount Code | nVarChar | 20 | OCDC | Â | Â | Â |
| DunningCod | Dunning Code | nVarChar | 20 | ORIT | Â | Â | Â |
| BslineDate | Due Date Based on | VarChar | 1 | - | T | P | Posting Date |
| Â | Â | Â | Â | Â | Â | S | System Date |
| Â | Â | Â | Â | Â | Â | T | Document Date |
| Â | Â | Â | Â | Â | Â | C | Closing Date |
| InstNum | No. of Installments | Int | 6 | - | Â | Â | Â |
| TolDays | No. of Tolerance Days | Int | 6 | - | Â | Â | Â |
| VATFirst | Apply Tax on 1st Installment | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Â | Â | Â | Â | Â | Â | T | Tax Only |
| CrdMthd | Credit Method | VarChar | 1 | - | L | F | First Installment |
| Â | Â | Â | Â | Â | Â | L | Last Installment |
| Â | Â | Â | Â | Â | Â | E | Equally |
| CshRelev | Cash Relevant Transaction | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| UserSign2 | Update User | Int | 6 | OUSR | Â | Â | Â |
| UpdateDate | Update Date | Date | 8 | - | Â | Â | Â |
| LogInstanc | Log Instance | Int | 11 | - | 0 | Â | Â |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| PDueMonEnd | End On | VarChar | 1 | - | N | E | End of Month |
| Â | Â | Â | Â | Â | Â | H | Middle of Month |
| Â | Â | Â | Â | Â | Â | Y | Start of Month |
| Â | Â | Â | Â | Â | Â | N | None |
| Key | Unique | Field |
| PRIMARY | Yes | GroupNum |
| ABS_ENTRY | Yes | PymntGroup |