| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AgrNo | Agreement No. | Int | 11 | OOAT | |||
| AgrLineNum | Agreement Row Number | Int | 11 | - | |||
| ItemCode | Item No. | nVarChar | 50 | OITM | |||
| ItemName | Item Description | nVarChar | 200 | - | |||
| ItemGroup | Item Group | Int | 6 | OITB | |||
| PlanQty | Planned Quantity | Num | 19.6 | - | |||
| UnitPrice | Unit Price | Num | 19.6 | - | |||
| Currency | Price Currency | nVarChar | 3 | - | |||
| CumQty | Cumulative Quantity | Num | 19.6 | - | |||
| CumAmntFC | Cumulative Amount in FC | Num | 19.6 | - | |||
| CumAmntLC | Cumulative Amount in LC | Num | 19.6 | - | |||
| FreeTxt | Free Text | nVarChar | 100 | - | |||
| InvntryUom | Inventory UoM | nVarChar | 100 | - | |||
| LogInstanc | Log Instance | Int | 11 | - | 0 | ||
| VisOrder | Visual Order | Int | 11 | - | |||
| RetPortion | Goods Return Probability | Num | 19.6 | - | |||
| WrrtyEnd | Date When Goods Expire | Date | 8 | - | |||
| LineStatus | Row Status | VarChar | 1 | - | O | O | Open |
| C | Closed | ||||||
| PlanAmtLC | Planned Amount (LC) | Num | 19.6 | - | |||
| PlanAmtFC | Planned Amount (FC) | Num | 19.6 | - | |||
| Discount | Line Discount | Num | 19.6 | - | |||
| UomEntry | UoM Entry | Int | 11 | OUOM | |||
| UomCode | UoM Code | nVarChar | 20 | - | |||
| NumPerMsr | UoM Value | Num | 19.6 | - | 0 | ||
| UndlvQty | Undeliverd Quantity | Num | 19.6 | - | |||
| UndlvAmntL | Undeliverd Amount LC | Num | 19.6 | - | |||
| UndlvAmntF | Undeliverd Amount FC | Num | 19.6 | - | |||
| TrnspCode | Shipping Type | Int | 6 | OSHP | |||
| Project | Project Code | nVarChar | 20 | OPRJ | |||
| TaxCode | Tax Code | nVarChar | 8 | - | |||
| TAXRate | TAX Rate | Num | 19.6 | - | |||
| PlVatAmtLC | Planned VAT Amount (LC) | Num | 19.6 | - | |||
| PlVatAmtFC | Planned VAT Amount (FC) | Num | 19.6 | - | |||
| CumVtAmtLC | Cumulative VAT Amount (LC) | Num | 19.6 | - | |||
| CumVtAmtFC | Cumulative VAT Amount (FC) | Num | 19.6 | - | |||
| EncryptIV | Encrypt IV | nVarChar | 100 | - | |||
| Key | Unique | Field |
| PRIMARY | Yes | AgrNo |
| AgrLineNum |