| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | SYS_NO | OIUH_DEC18 | decimal | 18 | 0 | DEC | ((0)) | No | | OIUH_DEC18 | |
| 3 | COMPANY | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | OIUH_CM_OR1 | OIUH_OR_LVL_1_NO | Allow NULL? |
| 4 | REMT | Business Associate | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | OIUCM_BUS_ASSOC | Allow NULL? |
| 5 | REMT_SEQ | Sequence Number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIUCM_SEQ_NO | Allow NULL? |
| 6 | ARMT_LVL_1 | A/R Remittance Level 1 code | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | OIUH_AR_REMIT_LVL_1_CODE | Allow NULL? |
| 7 | ARMT_LVL_2 | A/R Remittance Level 2 code | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | OIUH_AR_REMIT_LVL_2_CODE | Allow NULL? |
| 8 | SA_DT | Sales Date / Month | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | OIU_SALE_DT | Allow NULL? |
| 9 | PD_CD | Product | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | OIUH_PRODUCT | Allow NULL? |
| 10 | CUR_BAL | Local amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIUH_CURR13_2 | |
| 11 | STATUS | Accounts Receivable Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OIUAR_STATUS | Allow NULL? |
| 12 | ORIG_STATUS_AMT | Local amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIUH_CURR13_2 | |
| 13 | STATUS_USER | Accounts Receivable Status User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | OIUAR_STATUS_USER | Allow NULL? |
| 14 | AGE | Accounts Receivable Age | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | OIUAR_AGE | Allow NULL? |
| 15 | RESP_ID | Accounts Receivable Responsibility ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | OIUAR_RESP_ID | Allow NULL? |
| 16 | TOT_RECVBL | Local amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIUH_CURR13_2 | |
| 17 | TOT_CASHBL | Local amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIUH_CURR13_2 | |
| 18 | AWO_AMT | Local amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | OIUH_CURR13_2 | |
| 19 | AWO_USER | Accounts Receivable Writeoff User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | OIUAR_WO_USER | Allow NULL? |
| 20 | AGING_PERIOD | Accounting Period(YYYYMM01) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | OIUH_ACCOUNTING_PERIOD8 | Allow NULL? |
| 21 | USER_ID | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM | Allow NULL? |
| 22 | TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TZNTSTMPS | |