| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ACSTNO | Number of Returnable Packaging Account Statement | nvarchar | 12 | 0 | | | | Allow NULL? |
| 3 | CHNGTYPE | Processing status of account statement/transaction | char | 1 | 0 | | | | Allow NULL? |
| 4 | TRMNO_INT | Transfer Number (Internal) | nvarchar | 12 | 0 | | | | Allow NULL? |
| 5 | PARTNO | Sequence number for RP account postings per acct and deltype | int | 10 | 0 | | | | Allow NULL? |
| 6 | CUSTNO_PR | Customer number in account statement (main relationship) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 7 | SUPPNO_PR | Vendor number in account statement (main relationship) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 8 | MATCUSTNO | Returnable Packaging Number at Customer, as per Transmission | nvarchar | 35 | 0 | | | | Allow NULL? |
| 9 | MATSUPPNO | Returnable Packaging Number at Vendor, as per Transmission | nvarchar | 35 | 0 | | | | Allow NULL? |
| 10 | MATGR | Type of returnable packaging | nvarchar | 9 | 0 | | | | Allow NULL? |
| 11 | BALDATE | Acct statement date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | BAL | Balance (On Date of Statement) | decimal | 13 | 3 | | | | |
| 13 | ACSTUM | Unit of measure | nvarchar | 3 | 0 | | | | Allow NULL? |
| 14 | BALDATE_OLD | Old Posting Date (Balance Carried Forward) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 15 | BAL_OLD | Old Account Balance (Balance Carried Forward) | decimal | 13 | 3 | | | | |
| 16 | ACCTNO | Returnable packaging account | nvarchar | 12 | 0 | | | | Allow NULL? |
| 17 | ACCTNO_S | Number of Returnable Packaging Account at Sender | nvarchar | 12 | 0 | | | | Allow NULL? |
| 18 | CPSTATEHD | Matching status of returnable packaging account statement | char | 1 | 0 | | | | Allow NULL? |
