OIUE2_RV_CHD - Proc 2.0 - Check Details
Proc 2.0 - Check Details information is stored in SAP table OIUE2_RV_CHD.
It is part of development package OIU_E2 in software component IS-OIL-PRA-REV. This development package consists of objects that can be grouped under "Proc 2.0 - Escheat / Wyoming Escrow".
It is part of development package OIU_E2 in software component IS-OIL-PRA-REV. This development package consists of objects that can be grouped under "Proc 2.0 - Escheat / Wyoming Escrow".
Fields for table OIUE2_RV_CHD
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
RUN_ID | Proc 2.0 - Run ID | X | OIUE2_RUN_ID | NUMC | 20 | OIUE2_RUN_HDR |
CHD_OR_LVL_1_NO | Company Name Code | X | OIUH_COMPANY | CHAR | 6 | |
HD_ACCT_PERD_DT | Accounting Period Date | X | OIUH_ACCT_PERD_DT | CHAR | 28 | |
CHD_BTCH_NO | Batch Number | X | OIU_BATCH_NO | CHAR | 8 | |
CHD_VOU_NO | Voucher Number | X | OIUH_VOUCHER_NUMBER | CHAR | 12 | |
CHD_LE_NO | Check Line Number | X | OIUH_CHECK_LINE | CHAR | 16 | |
CHD_ACCT_NO | Account ID | OIUH_ACCTID | CHAR | 20 | ||
HD_BTCH_TYPE_CD | Batch Type | OIUH_BATCH_TYPE | CHAR | 4 | ||
D_LE_PRCS_ST_CD | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
CHD_TRANS_AM | JE Transaction Amount | OIUH_TRANS_AMT | CURR | 6 | ||
CHD_SYS_SRCE_CD | GL Source Code | OIUREP_GL_SYS_SRCE_CD | CHAR | 4 | ||
CHD_TRANS_QY | JE Transaction Quantity | OIUH_TRANS_QUANTITY | DEC | 6 | ||
CHD_GR_AM | Gross Amount (Value) | OIUH_GROSS_AMOUNT | CURR | 6 | ||
CHD_GR_QY | Gross Quantity | OIUH_GROSS_QTY | DEC | 6 | ||
CHD_PD_CD | Full three char. product code (Major and Detail Products) | OIU_FULL_PD_CD | CHAR | 6 | ||
CHD_VL_TYPE_CD | Volume Type Code | OIU_VL_TYPE_CD | CHAR | 4 | ||
CHD_CK_NO | Check Number | OIUH_CHECK_NUMBER | CHAR | 20 | ||
CHD_BNK_NO | Bank Identification | OIUCW_BANK_ID | CHAR | 18 | ||
CHD_BNK_ACC_NO | Bank Account | OIUCW_BANK_ACCT | CHAR | 18 | ||
CHD_VL_CLASS_CD | Volume Class Code | OIU_VL_CLS_CD | CHAR | 2 | ||
CHD_VL_SRCE_CD | Volume source code | OIUH_VOL_SOURCE_CODE | CHAR | 2 | ||
CHD_VL_FRQ_CD | Volume Frequency code | OIUH_VOL_FREQUENCY_CODE | CHAR | 2 | ||
CHD_BTU_QY | BTU Quantity | OIUH_BTU_QUANTITY | DEC | 4 | ||
HD_MMBTU_DET_CD | MMBTU Determination Code | OIUH_MMBTU_DET_CODE | CHAR | 2 | ||
CHD_PS_BASE_QY | Pressure Base Quantity | OIUH_PRESSURE_BASE | DEC | 4 | ||
CHD_GRV_QY | Gravity | OIUH_GRAVITY | DEC | 2 | ||
CHD_OWN_NO | Owner Number | OIUH_OWNER | CHAR | 12 | ||
CHD_OWN_SEQ_NO | Owner Sequence Number | OIUH_OWNER_SEQUENCE_NUMBER | CHAR | 4 | ||
CHD_PU_NO9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
CHD_PU_NO | Purchaser ID | OIUH_PURCHASER | CHAR | 12 | ||
CHD_PU_SEQ_NO9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
CHD_PU_SEQ_NO | Purchaser Sequence Number | OIUH_PURCHASER_SEQUENCE_NUMBER | CHAR | 4 | ||
CHD_PRDR_NO9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
CHD_PRDR_NO | Producer ID | OIUH_PRODUCER | CHAR | 12 | ||
CHD_PRDR_SEQ_NO9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
CHD_PRDR_SEQ_NO | Producer Sequence Number | OIUH_PRODUCER_SEQUENCE_NUMBER | CHAR | 4 | ||
CHD_OI_DECM_QY | Owner Interest Decimal Quantity | OIUH_OWN_INTEREST_DECIMAL_QTY | DEC | 5 | ||
CHD_OI_TYPE_CD | Owner Interest Type Code | OIUH_OWN_INTEREST_TYPE_CODE | CHAR | 4 | ||
D_OI_INT_SEQ_NO | Owner Interest Sequence Number | OIUH_OWN_INTEREST_SEQ_NUMBER | CHAR | 4 | ||
CHD_CK_DT | OIUH_CHAR14 | OIUH_CHAR14 | CHAR | 28 | ||
CHD_RVRS_RSN_CD | Reversal Reason Code | OIUH_RVRS_REASON_CODE | CHAR | 4 | ||
HD_UNIT_MEAS_CD | Unit of Measure Code | OIUH_UNIT_OF_MEASURE | CHAR | 6 | ||
HD_CASH_RCPT_DT9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
HD_CASH_RCPT_DT | Cash Receipt Date | OIUH_CASH_RCPT_DT | CHAR | 28 | ||
CHD_SUS_RSN_CD | Suspense Reason Code | OIUH_SUSPENSE_REASON_CODE | CHAR | 4 | ||
CHD_CT_NO9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
CHD_CT_NO | Contract ID | OIUH_CONTRACT_ID | CHAR | 12 | ||
CHD_CT_TYPE_CD | Contract Type code | OIUH_CONTRACT_TYPE_CODE | CHAR | 4 | ||
CHD_DOI_PR_NO | Property / DOI | OIUH_PROPERTY_DOI | CHAR | 16 | ||
CHD_DOI_SEQ_NO | Division of Interest (DOI) Number | OIUH_DOI_NO | CHAR | 10 | ||
CHD_TR_PR_NO9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
CHD_TR_PR_NO | Section Property Number | OIUH_SECTION_PROP_NUMBER | CHAR | 16 | ||
CHD_TR_SEQ_NO9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
CHD_TR_SEQ_NO | Section Sequence Number | OIUH_SECTION_SEQ_NUMBER | CHAR | 10 | ||
CHD_TRACE_CO_NO | Company Name Code | OIUH_COMPANY | CHAR | 6 | ||
D_TRACE_APRD_DT9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
D_TRACE_APRD_DT | OIUH_CHAR14 | OIUH_CHAR14 | CHAR | 28 | ||
D_TRACE_ACCT_NO | Account ID | OIUH_ACCTID | CHAR | 20 | ||
D_TRACE_BTCH_NO | Batch ID | OIUH_BATCH_ID | CHAR | 8 | ||
D_TRACE_VOUC_NO | Voucher Number | OIUH_VOUCHER_NUMBER | CHAR | 12 | ||
CHD_TRACE_LE_NO | Journal Entry Line Number | OIUH_JELINENO | CHAR | 16 | ||
CHD_WL_NO9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
CHD_WL_NO | Well ID Number | OIUH_WELL_NO | CHAR | 12 | ||
CHD_WC_NO9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
CHD_WC_NO | Well Completion Number | OIUH_WC_NO | CHAR | 4 | ||
CHD_DED_TOT_AM | Local amount | OIUH_CURR11_2 | CURR | 6 | ||
D_DED_TOT_GR_AM | Local amount | OIUH_CURR11_2 | CURR | 6 | ||
CHD_DED_RMB_AM | Deduction/Reimbursement Amount | OIUH_DED_REIMB_AMOUNT | CURR | 6 | ||
D_DED_GR_RMB_AM | Gross Deduction/Reimbursement amount | OIUH_DED_GR_REIMB_AMOUNT | CURR | 6 | ||
CHD_TAX_RMB_AM | Tax Reimbursement Amount | OIUH_TAX_REIMBURSEMENT_AMT | CURR | 6 | ||
D_TAX_GR_RMB_AM | Gross Tax Reimbursement Amount | OIUH_GROSS_TAX_REIMB_AMT | CURR | 6 | ||
CHD_INV_NO | Invoice Number | OIUH_INVOICE_NUMBER | CHAR | 12 | ||
CHD_INV_DT9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
CHD_INV_DT | OIUH_CHAR14 | OIUH_CHAR14 | CHAR | 28 | ||
CHD_PAY_CD | Pay Code | OIUH_PAY_CODE | CHAR | 4 | ||
CHD_SA_MP_NO | Measurement Point | OIUH_MP_NO | CHAR | 12 | ||
CHD_SA_DT | GL Sales Date | OIUREP_GL_SA_DT | CHAR | 28 | ||
CHD_ST_CD | State Code | OIUH_STATE_CODE | CHAR | 4 | ||
CHD_TAX_AUT_NO | Tax Authority Number | OIUH_TAX_AUTHORITY_NUMBER | CHAR | 12 | ||
TAX_AUT_SEQ_NO | Tax Authority Sequence Number | OIUH_TAX_AUTHORITY_SEQ_NUMBER | CHAR | 4 | ||
OWN_BAL_DEC_QY | Owner Disbursement (Balance) Decimal | OIUH_OWNER_DISBUR_DECIMAL | DEC | 5 | ||
CHD_PR_TYPE_CD | Property Type Code | OIUH_PROPERTY_TYPE_CODE | CHAR | 4 | ||
HD_OP_NON_OP_FL | Operated Flag | OIUH_OPERATED_FLAG | CHAR | 2 | ||
CHD_PU_PR_NO | Purchaser Property Number | OIUH_PURCHASER_PROPERTY_NUMBER | CHAR | 36 | ||
CHD_PU_PD_NO | Purchaser Product Code | OIUH_PURCHASER_PRODUCT_CODE | CHAR | 6 | ||
CHD_REJ_FL | Line item Reject Flag (Y=Yes, N=No) | OIUH_REJECT_FLAG | CHAR | 2 | ||
CHD_UNIT_PR_NO | Unit Property Number | OIUH_UNIT_PROPERTY_NUMBER | CHAR | 16 | ||
D_ARMT_LVL_1_CD | A/R Remittance Level 1 code | OIUH_AR_REMIT_LVL_1_CODE | CHAR | 16 | ||
D_ARMT_LVL_2_CD | A/R Remittance Level 2 code | OIUH_AR_REMIT_LVL_2_CODE | CHAR | 10 | ||
CHD_TRANS_DE9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
CHD_TRANS_DE | Descriptive Text for financial transaction | OIUH_DESCRIPTION | CHAR | 120 | ||
CHD_INT_PAID_FL | Interest Paid Flag | OIUH_INTEREST_PAID_FLAG | CHAR | 2 | ||
CHD_OWN_GRVA_AM | Local amount | OIUH_CURR11_2 | CURR | 6 | ||
D_PLT_VL_RED_AM | Gross Plant Volume Reduction amount | OIUH_GROSS_PLANT_VOLUME_RED_AM | DEC | 6 | ||
CHD_LGND_CD | Legend Code | OIUH_LEGEND_CODE | CHAR | 4 | ||
CHD_CMT_SYS_NO9 | OIUH_CHAR1 | OIUH_CHAR1 | CHAR | 2 | ||
CHD_CMT_SYS_NO | Comment System Number | OIUH_COMMENT_SYSTEM_NUMBER | DEC | 10 | ||
CHD_VER_NO | OIUH_DEC5 | OIUH_DEC5 | DEC | 3 | ||
CHD_USER_ID | User ID | OIUH_USER_ID | CHAR | 16 | ||
CHD_TIMESTAMP | Time Stamp | OIUH_TT_TIMESTAMP | CHAR | 28 |