| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | AbsID | Agreement No. | int | 11 | 0 | | | | Allow NULL? |
| 2 | BpCode | BP Code | nvarchar | 15 | 0 | OCRD | | | Allow NULL? |
| 3 | BpName | BP Name | nvarchar | 100 | 0 | | | | Allow NULL? |
| 4 | CntctCode | Contact Person | int | 11 | 0 | OCPR | | | Allow NULL? |
| 5 | StartDate | Start Date | date | 8 | 0 | | | | |
| 6 | EndDate | End Date | date | 8 | 0 | | | | |
| 7 | TermDate | Termination Date | date | 8 | 0 | | | | |
| 8 | Descript | Description | nvarchar | 254 | 0 | | | | Allow NULL? |
| 9 | Type | Agreement Type | char | 1 | 0 | | G | G=General, S=Specific | Allow NULL? |
| 10 | Status | Agreement Status | char | 1 | 0 | | D | A=Approved, C=Canceled, D=Draft, F=On Hold, P=To Be On Hold, T=Terminated, X=To Be Terminated | Allow NULL? |
| 11 | Owner | Owner | int | 11 | 0 | OHEM | | | Allow NULL? |
| 12 | Renewal | Renewal | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 13 | UseDiscnt | Use BP Special Price | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 14 | RemindVal | Reminder | int | 6 | 0 | | | | Allow NULL? |
| 15 | RemindUnit | Reminder Unit | char | 1 | 0 | | D | D=Day(s), M=Month(s), W=Week(s) | Allow NULL? |
| 16 | Remarks | Remarks | text | 16 | 0 | | | | |
| 17 | AtchEntry | Attachment Entry | int | 11 | 0 | OATC | | | Allow NULL? |
| 18 | LogInstanc | Log Instance | int | 11 | 0 | | 0 | | Allow NULL? |
| 19 | UserSign | User Signature | int | 6 | 0 | OUSR | | | Allow NULL? |
| 20 | UserSign2 | User Signature 2 | int | 6 | 0 | OUSR | | | Allow NULL? |
| 21 | UpdtDate | Update Date | date | 8 | 0 | | | | |
| 22 | CreateDate | Create Date | date | 8 | 0 | | | | |
| 23 | Cancelled | Canceled | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 24 | DataSource | Data Source | char | 1 | 0 | | N | A=Auto Summary, D=Restore Wizard, I=Interface, M=Import, N=Unknown, O=DI API, P=Partner Implementation, T=Year of Transfer, U=Upgrade | Allow NULL? |
| 25 | Transfered | Year Transfer | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 26 | RemindFlg | Reminder Sent | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 27 | Fulfilled | Fulfilled | char | 1 | 0 | | N | N=Not Fulfilled, Y=Fulfilled | Allow NULL? |
| 28 | Attachment | Attachments | text | 16 | 0 | | | | |
| 29 | SettleProb | Settlement Probability % | num | 19 | 6 | | | | Allow NULL? |
| 30 | UpdtTime | Update Time | int | 11 | 0 | | | | Allow NULL? |
| 31 | Method | Agreement Method | char | 1 | 0 | | I | I=Items Method, M=Monetary Method | Allow NULL? |
| 32 | GroupNum | Payment Terms Code | int | 6 | 0 | OCTG | | | Allow NULL? |
| 33 | ListNum | Price List No. | int | 6 | 0 | OPLN | | | Allow NULL? |
| 34 | SignDate | Signing Date | date | 8 | 0 | | | | |
| 35 | AmendedTo | Amendment To | int | 11 | 0 | | | | Allow NULL? |
| 36 | Series | Series | int | 11 | 0 | NNM1 | | | Allow NULL? |
| 37 | Number | Number | int | 11 | 0 | | | | Allow NULL? |
| 38 | ObjType | Object Type | nvarchar | 20 | 0 | ADP1 | 1250000025 | | Allow NULL? |
| 39 | Handwrtten | Manual Numbering | char | 1 | 0 | | N | | Allow NULL? |
| 40 | PIndicator | Period Indicator | nvarchar | 10 | 0 | OPID | | | Allow NULL? |
| 41 | BpType | BP Type | char | 1 | 0 | | C | C=Customer, S=Vendor | Allow NULL? |
| 42 | Instance | Instance | int | 6 | 0 | | 0 | | Allow NULL? |
| 43 | PayMethod | Payment Method | nvarchar | 15 | 0 | OPYM | | | Allow NULL? |
| 44 | NumAtCard | Customer/Vendor Ref. No. | nvarchar | 100 | 0 | | | | Allow NULL? |
| 45 | BPCurr | BP Currency | nvarchar | 3 | 0 | OCRN | | | Allow NULL? |
| 46 | FixedRate | Exchange Rate | num | 19 | 6 | | | | Allow NULL? |
| 47 | TrnspCode | Shipping Type | int | 6 | 0 | OSHP | | | Allow NULL? |
| 48 | Project | Project Code | nvarchar | 20 | 0 | OPRJ | | | Allow NULL? |
| 49 | PriceMode | Price Mode | char | 1 | 0 | | N | G=Gross, N=Net | Allow NULL? |
| 50 | WddStatus | Authorization Status | char | 1 | 0 | | - | -=Without, A=Generated by Authorizer, C=Canceled, N=Rejected, P=Generated, W=Pending, Y=Approved | Allow NULL? |
| 51 | FromStat | From Status | char | 1 | 0 | | D | D=Draft, F=On Hold | Allow NULL? |
| 52 | DPPStatus | Data Protection Status | char | 1 | 0 | | N | D=Erased, N=None | Allow NULL? |
| 53 | SAPPassprt | Extended SAP Passport | text | 16 | 0 | | | | |
