OIUH_RV_ARINTF - PRA Journal Entries to A/R interface table
PRA Journal Entries to A/R interface table information is stored in SAP table OIUH_RV_ARINTF.
It is part of development package OIU_H in software component IS-OIL-PRA-REV. This development package consists of objects that can be grouped under "PRA Hybrid Solution".
It is part of development package OIU_H in software component IS-OIL-PRA-REV. This development package consists of objects that can be grouped under "PRA Hybrid Solution".
Fields for table OIUH_RV_ARINTF
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | |
OR_LVL_1_NO | Company Name Code | X | OIUH_COMPANY | CHAR | 6 | |
ACCT_PERD_DT | Accounting Period(YYYYMM01) | X | OIUH_ACCOUNTING_PERIOD8 | CHAR | 16 | |
BTCH_NO | Batch ID | X | OIUH_BATCH_ID | CHAR | 8 | |
LE_NO | Journal Entry Line Number | X | OIUH_JELINENO | CHAR | 16 | |
VOU_NO | Voucher Number | OIUH_VOUCHER_NUMBER | CHAR | 12 | ||
REJ_FL | Line item Reject Flag (Y=Yes, N=No) | OIUH_REJECT_FLAG | CHAR | 2 | ||
ACCT_NO | Account ID | OIUH_ACCTID | CHAR | 20 | ||
ACCT_TYPE_CD | Account Type | OIUH_ACCTYPE | CHAR | 4 | ||
ACCT_CAT_NO | Account category code | OIU_ACCT_CAT_CD | CHAR | 8 | ||
BTCH_TYP_CD | Batch Type | OIUH_BATCH_TYPE | CHAR | 4 | ||
LE_PRCS_ST_CD | Journal Entry Line Status | OIUH_JELINEST | CHAR | 2 | ||
SYS_SRCE_CD | PRA application component source | OIUH_SUB_SYSTEM_SOURCE | CHAR | 4 | ||
TRANS_AM | JE Transaction Amount | OIUH_TRANS_AMT | CURR | 6 | ||
TRANS_QY | JE Transaction Quantity | OIUH_TRANS_QUANTITY | DEC | 6 | ||
GR_AM | Gross Amount (Value) | OIUH_GROSS_AMOUNT | CURR | 6 | ||
GR_QY | Gross Quantity | OIUH_GROSS_QTY | DEC | 6 | ||
PD_CD | Product Code | OIUH_PRODUCT_CODE | CHAR | 6 | ||
CK_NO | Check Number | OIUH_CHECK_NUMBER | CHAR | 20 | ||
CK_DT | Check Date | OIUH_CHECKDATE | CHAR | 20 | ||
VL_TYPE_CD | Volume Type | OIUH_VOLTYPE | CHAR | 4 | ||
VL_CLASS_CD | Volume Class Code | OIUH_VOL_CLASS_CODE | CHAR | 2 | ||
VL_SRCE_CD | Volume source code | OIUH_VOL_SOURCE_CODE | CHAR | 2 | ||
VL_FRQ_CD | Volume Frequency code | OIUH_VOL_FREQUENCY_CODE | CHAR | 2 | ||
BTU_QY | BTU Quantity | OIUH_BTU_QUANTITY | DEC | 4 | ||
MMBTU_DET_CD | MMBTU Determination Code | OIUH_MMBTU_DET_CODE | CHAR | 2 | ||
PS_BASE_QY | Pressure Base Quantity | OIUH_PRESSURE_BASE | DEC | 4 | ||
GRV_QY | Gravity | OIUH_GRAVITY | DEC | 2 | ||
OWN_NO | Owner Number | OIUH_OWNER | CHAR | 12 | ||
OWN_SEQ_NO | Owner Sequence Number | OIUH_OWNER_SEQUENCE_NUMBER | CHAR | 4 | ||
PU_NO | Purchaser Number | OIUH_PU_NO | CHAR | 12 | ||
PU_SEQ_NO | Purchaser Sequence Number | OIUH_PURCHASER_SEQUENCE_NUMBER | CHAR | 4 | ||
PRDR_NO | Producer ID | OIUH_PRODUCER | CHAR | 12 | ||
PRDR_SEQ_NO | Producer Sequence Number | OIUH_PRODUCER_SEQUENCE_NUMBER | CHAR | 4 | ||
OWN_INT_DECM_QY | Owner Interest Decimal Quantity | OIUH_OWN_INTEREST_DECIMAL_QTY | DEC | 5 | ||
OWN_INT_TYPE_CD | Owner Interest Type Code | OIUH_OWN_INTEREST_TYPE_CODE | CHAR | 4 | ||
OWN_INT_SEQ_NO | Owner Interest Sequence Number | OIUH_OWN_INTEREST_SEQ_NUMBER | CHAR | 4 | ||
RVRS_RSN_CD | Reversal Reason Code | OIUH_RVRS_REASON_CODE | CHAR | 4 | ||
UNIT_OF_MEAS_CD | Unit of Measure Code | OIUH_UNIT_OF_MEASURE | CHAR | 6 | ||
CASH_RCPT_DT | Cash Receipt Date | OIUH_CASH_RECEIPT_DATE | CHAR | 20 | ||
SUS_RSN_CD | Suspense Reason Code | OIUH_SUSPENSE_REASON_CODE | CHAR | 4 | ||
CT_NO | Contract ID | OIUH_CONTRACT_ID | CHAR | 12 | ||
CT_TYPE_CD | Contract Type code | OIUH_CONTRACT_TYPE_CODE | CHAR | 4 | ||
DOI_PR_NO | Property | OIUH_PR_NO | CHAR | 16 | ||
DOI_SEQ_NO | Division of Interest (DOI) Number | OIUH_DOI_NO | CHAR | 10 | ||
SECT_PR_NO | Section Property Number | OIUH_SECTION_PROP_NUMBER | CHAR | 16 | ||
SECT_SEQ_NO | Section Sequence Number | OIUH_SECTION_SEQ_NUMBER | CHAR | 10 | ||
TRACE_CO_NO | Company Name Code | OIUH_COMPANY | CHAR | 6 | ||
TRACE_APRD_DT | Accounting Period(YYYYMM01) | OIUH_ACCOUNTING_PERIOD8 | CHAR | 16 | ||
TRACE_ACCT_NO | Account ID | OIUH_ACCTID | CHAR | 20 | ||
TRACE_BTCH_NO | Batch ID | OIUH_BATCH_ID | CHAR | 8 | ||
TRACE_VOUC_NO | Voucher Number | OIUH_VOUCHER_NUMBER | CHAR | 12 | ||
TRACE_LE_NO | Journal Entry Line Number | OIUH_JELINENO | CHAR | 16 | ||
TRACE_BTCH_TY | Batch Type | OIUH_BATCH_TYPE | CHAR | 4 | ||
WL_NO | Well ID Number | OIUH_WELL_NO | CHAR | 12 | ||
WC_NO | Well Completion ID | OIUH_WELL_COMPLETION_ID | CHAR | 4 | ||
ORIG_MP | Originating Measurement Point Number | OIUH_ORIGINATING_MP_NO | CHAR | 12 | ||
ORIG_MP_TYPE | Originating Measurement Point Type | OIUH_ORIGINATING_MP_TYPE | CHAR | 4 | ||
DED_RMB_AM | Deduction/Reimbursement Amount | OIUH_DED_REIMB_AMOUNT | CURR | 6 | ||
DED_GR_RMB_AM | Gross Deduction/Reimbursement amount | OIUH_DED_GR_REIMB_AMOUNT | CURR | 6 | ||
TAX_1_AM | Tax amount | OIUH_TAX_AMOUNT | CURR | 6 | ||
TAX_2_AM | Tax amount | OIUH_TAX_AMOUNT | CURR | 6 | ||
TAX_3_AM | Tax amount | OIUH_TAX_AMOUNT | CURR | 6 | ||
TAX_4_AM | Tax amount | OIUH_TAX_AMOUNT | CURR | 6 | ||
TAX_5_AM | Tax amount | OIUH_TAX_AMOUNT | CURR | 6 | ||
TAX_6_AM | Tax amount | OIUH_TAX_AMOUNT | CURR | 6 | ||
TAX_7_AM | Tax amount | OIUH_TAX_AMOUNT | CURR | 6 | ||
TAX_8_AM | Tax amount | OIUH_TAX_AMOUNT | CURR | 6 | ||
TAX_9_AM | Tax amount | OIUH_TAX_AMOUNT | CURR | 6 | ||
TAX_10_AM | Tax amount | OIUH_TAX_AMOUNT | CURR | 6 | ||
TAX_RMB_AM | Tax Reimbursement Amount | OIUH_TAX_REIMBURSEMENT_AMT | CURR | 6 | ||
TAX_GR_RMB_AM | Gross Tax Reimbursement Amount | OIUH_GROSS_TAX_REIMB_AMT | CURR | 6 | ||
INV_NO | Invoice Number | OIUH_INVOICE_NUMBER | CHAR | 12 | ||
INV_DT | Invoice Date | OIUH_INVOICE_DATE | CHAR | 20 | ||
INV_TYPE_CD | Invoice Type code | OIUH_INVOICE_TYPE_CODE | CHAR | 4 | ||
PAY_CD | Pay Code | OIUH_PAY_CODE | CHAR | 4 | ||
SA_MP_NO | Sales Measurement Point Number | OIUH_SALES_MP_NUMBER | CHAR | 12 | ||
SA_DT | Sales Date | OIUH_SALES_DATE | CHAR | 20 | ||
STATE_CD | State Code | OIUH_STATE_CODE | CHAR | 4 | ||
TAX_AUTH_NO | Tax Authority Number | OIUH_TAX_AUTHORITY_NUMBER | CHAR | 12 | ||
TAX_AUTH_SEQ_NO | Tax Authority Sequence Number | OIUH_TAX_AUTHORITY_SEQ_NUMBER | CHAR | 4 | ||
OWN_BAL_DECM_QY | Owner Disbursement (Balance) Decimal | OIUH_OWNER_DISBUR_DECIMAL | DEC | 5 | ||
PR_TYPE_CD | Property Type Code | OIUH_PROPERTY_TYPE_CODE | CHAR | 4 | ||
OP_NON_OP_FL | Operated Flag | OIUH_OPERATED_FLAG | CHAR | 2 | ||
PU_PR_NO | Purchaser Property Number | OIUH_PURCHASER_PROPERTY_NUMBER | CHAR | 36 | ||
PU_PD_CD | Purchaser Product Code | OIUH_PURCHASER_PRODUCT_CODE | CHAR | 6 | ||
UNIT_PR_NO | Unit Property Number | OIUH_UNIT_PROPERTY_NUMBER | CHAR | 16 | ||
ARMT_LVL_1_CD | A/R Remittance Level 1 code | OIUH_AR_REMIT_LVL_1_CODE | CHAR | 16 | ||
ARMT_LVL_2_CD | A/R Remittance Level 2 code | OIUH_AR_REMIT_LVL_2_CODE | CHAR | 10 | ||
TRANS_DE | Descriptive Text for financial transaction | OIUH_DESCRIPTION | CHAR | 120 | ||
NET_TRANSP_AM | Net Transportation Amount | OIUH_TRANSPORTATION_AMT | CURR | 6 | ||
NET_OTH_MK_AM | Net Other Marketing Amount | OIUH_NET_OTH_MARKETING_AMOUNT | CURR | 6 | ||
GR_TRANSP_AM | Gross Transportation Amount | OIUH_GROSS_TRANP_AMOUNT | CURR | 6 | ||
GR_OTH_MK_AM | Gross Other Marketing Amount | OIUH_GROSS_OTH_MARKETING_AMT | CURR | 6 | ||
OTH_DED_01_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_02_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_03_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_04_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_05_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_06_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_07_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_08_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_09_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_10_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_11_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_12_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_13_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_14_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_15_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_16_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_17_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
OTH_DED_18_AM | Other Deductions Amount | OIUH_OTHER_DEDUCTION_AMOUNT | CURR | 6 | ||
PROC_CO | Processing Company code | OIUH_PROCESSING_COMPANY_CODE | CHAR | 6 | ||
AES_FL | Actual / Entitled / Settlement Code | OIU_AES_CD | CHAR | 2 | ||
TAX_CD | Tax Code | OIUH_TAX_CODE | CHAR | 4 | ||
GRP_GROUP_NO | Group Number | OIUH_GROUP_NUMBER | CHAR | 16 | ||
INT_SYMBOL | Interest Symbol | OIUH_INTEREST_SYMBOL | CHAR | 4 | ||
TXN_VAL_AM | Transaction Owner Amount | OIUH_TRAN_OWNER_AMOUNT | CURR | 6 | ||
TXN_DT | Transaction Date | OIUH_TRANS_DATE | CHAR | 20 | ||
GAS_PLANT_NO | Gas Plant Property Number | OIUH_GAS_PLANT_PROPERTY_NUMBER | CHAR | 16 | ||
GAS_PLANT_DOI | Gas Plant DOI Number | OIUH_GAS_PLANT_DOI_NUMBER | CHAR | 10 | ||
REF_NO | Reference Number | OIUH_REFERENCE_NUMBER | CHAR | 20 | ||
SELLER_NO | Seller Number | OIUH_SELLER_NUMBER | CHAR | 12 | ||
SELLER_SEQ_NO | Seller Sequence Number | OIUH_SELLER_SEQUENCE_NUMBER | CHAR | 4 | ||
NWK_NO | Delivery Network number | OIUH_DN_NO | CHAR | 8 | ||
SUBNWK_NO | Subnetwork Number | OIUH_SUBNWK_NO | CHAR | 8 | ||
AUDIT_BTCH_NO | Audit Batch Number | OIUH_AUDIT_BATCH_NUMBER | CHAR | 8 | ||
JDI_PR_NO | JDI Expense Property Number | OIUH_JDI_PROPERTY_NUMBER | CHAR | 16 | ||
JDI_NO | JDI Expense Property Sequence Number | OIUH_JDI_PROPERTY_SEQ_NUMBER | CHAR | 10 | ||
DI_PR_NO | Expense Property Number | OIUH_DI_PROPERTY_NUMBER | CHAR | 16 | ||
DI_NO | Expense Property Sequence Number | OIUH_DI_PROPERTY_SEQ_NUMBER | CHAR | 10 | ||
REMT_NO | Remitter ID | OIUH_REMITTER_ID | CHAR | 12 | ||
REMT_SEQ_NO | Remitter Sequence Number | OIUH_REMITTER_SEQUENCE_NUMBER | CHAR | 4 | ||
RCV_GL_WL_NO | Off Lease Well Number | OIUH_OFF_LEASE_WELL_NUMBER | CHAR | 12 | ||
RCV_GL_WC_NO | Off Lease Well Completion Number | OIUH_OFF_LEASE_WELL_COMPLETION | CHAR | 4 | ||
REL_CT_NO | REL Contract Number | OIUH_REL_CONTRACT_NUMBER | CHAR | 12 | ||
PLT_VL_GRED_AM | Gross Plant Volume Reduction amount | OIUH_GROSS_PLANT_VOLUME_RED_AM | DEC | 6 | ||
PLT_VL_ORED_AM | Owner Plant Volume Reduction amount | OIUH_OWNER_PLANT_VOLUME_RED_AM | DEC | 6 | ||
INT_PAID_FL | Interest Paid Flag | OIUH_INTEREST_PAID_FLAG | CHAR | 2 | ||
MMBTU_OVL_AM | Owner MMBTU | OIUH_OWNER_MMBTU | DEC | 6 | ||
MMBTU_GRVL_AM | MMBTU Gross Volume | OIUH_MMBTU | DEC | 6 | ||
PHASE_NO | Phase number | OIUVL_PHASE_NO | CHAR | 2 | ||
PD_CD_SUM_IND | Product Code Summarize Indicator | OIUH_PRODUCT_CODE_SUMMARIZE_IN | CHAR | 2 | ||
VL_LEVEL_CD | Valuation Level Code | OIUH_VALUATION_LEVEL_CODE | CHAR | 4 | ||
CHV_RPT_CD | Template Cost Center | RKOSTL | CHAR | 20 | ||
GR_TAX_1_AM | Gross Tax Amount | OIUH_GROSS_TAX_AMOUNT | CURR | 7 | ||
GR_TAX_2_AM | Gross Tax Amount | OIUH_GROSS_TAX_AMOUNT | CURR | 7 | ||
GR_TAX_3_AM | Gross Tax Amount | OIUH_GROSS_TAX_AMOUNT | CURR | 7 | ||
GR_TAX_4_AM | Gross Tax Amount | OIUH_GROSS_TAX_AMOUNT | CURR | 7 | ||
GR_TAX_5_AM | Gross Tax Amount | OIUH_GROSS_TAX_AMOUNT | CURR | 7 | ||
GR_TAX_6_AM | Gross Tax Amount | OIUH_GROSS_TAX_AMOUNT | CURR | 7 | ||
GR_TAX_7_AM | Gross Tax Amount | OIUH_GROSS_TAX_AMOUNT | CURR | 7 | ||
GR_TAX_8_AM | Gross Tax Amount | OIUH_GROSS_TAX_AMOUNT | CURR | 7 | ||
GR_TAX_9_AM | Gross Tax Amount | OIUH_GROSS_TAX_AMOUNT | CURR | 7 | ||
GR_TAX_10_AM | Gross Tax Amount | OIUH_GROSS_TAX_AMOUNT | CURR | 7 | ||
SPEC_PYMNT_CD | Special Payment Code | OIUH_SPECIAL_PAYMENT_CODE | CHAR | 2 | ||
LGND_CD | Legend Code | OIUH_LEGEND_CODE | CHAR | 4 | ||
RBUR_DEC | Royalty Burden Decimal | OIUH_ROYALTY_BURDEN_DECIMAL | DEC | 5 | ||
ESCH_FL | Escheat Flag | OIUH_ESCHEAT_FLAG | CHAR | 2 | ||
CMT_SYS_NO | Comment System Number | OIUH_COMMENT_SYSTEM_NUMBER | DEC | 10 | ||
OVRD_OWN_CD | Override Owner code | OIU_OVRD_OWN_CD | CHAR | 4 | ||
BRD_CD | Brand Code | OIUH_BRAND_CODE | CHAR | 8 | ||
RCPTN_PT_NO | Reception Point Number | OIUH_RECEPTION_POINT_NUMBER | CHAR | 12 | ||
TRNSP_NO | Transporter Number | OIUH_TRANSPORTER_NUMBER | CHAR | 12 | ||
TRNSP_SEQ_NO | Transporter Sequence Number | OIUH_TRANSPORTER_SEQ_NUMBER | CHAR | 4 | ||
OR_LVL_2_NO | Region Code (Org. Lvl 2) | OIUH_REGION_CODE | CHAR | 2 | ||
MK_TYPE_NO | Marketing Type Number | OIUH_MARKETING_TYPE_NUMBER | CHAR | 4 | ||
ORIG_PR_NO | Originating Property Number | OIUH_ORGINATING_PROPERTY_NO | CHAR | 16 | ||
INJ_DT | Injection Date | OIUH_INJECTION_DATE | CHAR | 20 | ||
GR_APC_RMB | Gross APC Reimbursement | OIUH_GROSS_APC_REIMBURSEMENT | CURR | 7 | ||
NET_APC_RMB | Net APC Reimbursement Amount | OIUH_NET_APC_REIMBURSEMENT | CURR | 7 | ||
JI_OWN_NO | JI Owner Number | OIUH_JI_OWNER_NUMBER | CHAR | 12 | ||
JI_OWN_SEQ_NO | JI Owner Sequence Number | OIUH_JI_OWNER_SEQUENCE_NUMBER | CHAR | 4 | ||
DEAL_I_NO | Deal I Number | OIUH_DEAL_I_NUMBER | CHAR | 24 | ||
CUSA_TRSPK_NO | CUSA Transportation Number | OIUH_CUSA_TRANSPORTATION_NO | CHAR | 16 | ||
VER_NO | Version Number | OIUH_TT_VER_NO | DEC | 3 | ||
USER_ID | User ID | OIUH_USER_ID | CHAR | 16 | ||
TIMESTAMP | Time Stamp | OIUH_TT_TIMESTAMP | CHAR | 28 | ||
ERROR_1_CD | JE posting Validation Error Code | OIUH_ERROR_CODE | CHAR | 10 | ||
ERROR_2_CD | JE posting Validation Error Code | OIUH_ERROR_CODE | CHAR | 10 | ||
ERROR_3_CD | JE posting Validation Error Code | OIUH_ERROR_CODE | CHAR | 10 | ||
ERROR_4_CD | JE posting Validation Error Code | OIUH_ERROR_CODE | CHAR | 10 | ||
ERROR_5_CD | JE posting Validation Error Code | OIUH_ERROR_CODE | CHAR | 10 |