DW_AP_PREPAY_APP_DISTS_EN

This is the entity table for distribution of prepayment application invoice distributions to the recipient invoice distribution.

Details

Module: Payables

Key Columns

PREPAY_APP_DIST_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PREPAY_APP_DIST_ID NUMBER 38 0 True The unique Identifier of the prepayment application distribution. This is the primary key of the Prepayment Application Distributions view object.    
SOURCE_RECORD_ID NUMBER 38 0   Source record identifier. Value is derived from a combination of invoice identifier and LineNumber    
SUBLEDGER_LINKAGE_DST_ENTITY_ID VARCHAR2 128     The unique Identifier of the prepayment application distribution. This is the primary key of the Prepayment Application Distributions view object.    
PREPAY_DIST_LOOKUP_CODE VARCHAR2 32     The name of the distribution type. A list of accepted values is defined in the lookup type INVOICE DISTRIBUTION TYPE.    
AMOUNT NUMBER       The prorated invoice distribution amount of the prepayment that is applied to the invoice.    
BASE_AMOUNT NUMBER       The prorated invoice distribution amount in the ledger currency that is derived using the invoice conversion rate.    
PREPAY_APP_DISTRIBUTION_ID NUMBER 38 0   The unique identifier of the prepayment invoice distribution.    
D_INVOICE_DISTRIBUTION_ID NUMBER 38 0   The unique identifier of the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.    
D_INVOICE_LINE_NUMBER NUMBER       The unique number for the invoice line associated with the invoice distribution.    
D_DISTRIBUTION_LINE_NUMBER NUMBER 38 0   The line number associated with the invoice distribution.    
D_ACCOUNTING_DATE DATE       The date when the invoice distribution is to be accounted.    
D_LINE_TYPE_LOOKUP_CODE VARCHAR2 32     The type of invoice line associated with the invoice distribution. A list of accepted values is defined in the lookup type INVOICE DISTRIBUTION TYPE.    
D_POSTED_FLAG VARCHAR2 16     Indicates whether the invoice distribution line has been accounted.    
D_CANCELLATION_FLAG VARCHAR2 16     Indicates whether an invoice distribution is canceled. The default value is false. If the value if true, then it indicates the invoice distribution is canceled.    
D_AMOUNT NUMBER       The amount on the invoice distribution.    
D_BASE_AMOUNT NUMBER       The invoice distribution amount in the ledger currency. This is only used for foreign currency invoices.    
D_CREATED_BY VARCHAR2 128     The user who created the invoice distribution.    
D_LAST_UPDATED_BY VARCHAR2 128     The user who last updated the invoice distribution. This attribute forms part of the primary key for the Invoice Distributions view object.    
D_RCV_TRANSACTION_ID NUMBER 38 0   The identifier of the receipt of material that originated the invoice distribution.    
D_INVOICE_ID NUMBER 38 0   The unique identifier of the invoice associated with the invoice distribution. DW_AP_INVOICES_EN  
D_DESCRIPTION VARCHAR2 256     The description of the invoice distribution.    
D_DIST_CODE_COMBINATION_ID NUMBER 38 0   The identifier of the accounting flexfield for the account associated with the distribution. DW_GL_CODE_COMBINATION_D  
D_REVERSAL_FLAG VARCHAR2 16     Indicates whether a distribution is part of a reversal pair. The default value is false. If the value if true, then it indicates that the distribution is part of a reversal pair.    
D_DIST_MATCH_TYPE VARCHAR2 32     Indicates if the invoice is matched to a purchase order or to a receipt of material. A list of accepted values is defined in the lookup type INVOICE LINE MATCH TYPE.    
D_PO_DISTRIBUTION_ID NUMBER 38 0   Purchase order distribution identifier for purchase order or receipt matched invoice distributions    
D_ASSETS_TRACKING_FLAG VARCHAR2 16     Flag that indicates if distribution is tracked in Oracle Assets. Possible values are Y or N    
D_MATCHED_UOM_LOOKUP_CODE VARCHAR2 32     UOM used for the quantity invoiced during matching of this distributions    
D_UNIT_PRICE NUMBER       Unit price for purchase order, receipt matched invoice distributions, and price or quantity corrections    
D_QUANTITY_INVOICED NUMBER       Quantity billed for purchase order or receipt matched invoice distributions    
D_MATCH_STATUS_FLAG VARCHAR2 16     Indicates whether the invoice distribution is generated for a purchase order matched line.    
L_INVOICE_ID NUMBER 38 0   Invoice line number associated with the event.    
L_LINE_NUMBER NUMBER 38 0   Number of the invoice line.    
L_AMOUNT NUMBER       Line amount in invoice currency    
L_LINE_TYPE_LOOKUP_CODE VARCHAR2 32     The type of invoice line. The value must be provided while creating an invoice line. A list of accepted values is defined in the lookup type INVOICE LINE TYPE    
L_ACCOUNTING_DATE DATE       The accounting date for the invoice line. It is used to default the accounting date to invoice distributions.    
L_CANCELLED_FLAG VARCHAR2 16     Indicates whether an invoice line is canceled. Possible values are null, Y or N. If the value is Y, then it indicates that the line has been canceled.    
L_PREPAY_INVOICE_ID NUMBER 38 0   The identifier of the prepayment invoice applied to the invoice line.    
L_PREPAY_LINE_NUMBER NUMBER       The line number of the prepayment line applied to the invoice line.    
L_LINE_SOURCE VARCHAR2 32     Source of the invoice line. Validated against AP_LOOKUP_CODES.LOOKUP_CODE for LOOKUP_TYPE LINE SOURCE    
L_REQUESTER_ID NUMBER 38 0   The name of the person who the requested items are intended for.    
L_PURCHASING_CATEGORY_ID NUMBER 38 0   Item category unique identifier    
L_DESCRIPTION VARCHAR2 256     Description of the invoice line.    
L_CONSUMPTION_ADVICE_LINE_ID NUMBER 38 0   Consumption advice line identifier. Used for consumption advice matching.    
L_SHIP_TO_LOCATION_ID NUMBER 38 0   Tax Driver: Ship to location ID. Value entered by user only if line is not PO matched.    
L_INVENTORY_ITEM_ID NUMBER       Inventory item identifier. Validated against EGP_SYSTEM_ITEMS.INVENTORY_ITEM_ID    
L_ITEM_DESCRIPTION VARCHAR2 256     Description of the item in the invoice line.    
L_PRODUCT_TYPE VARCHAR2 256     Tax Driver: Type of product. Possible values are: Goods, Service. This value will default from Inventory Item attributes. Otherwise, value will be entered by user.    
L_UNIT_PRICE NUMBER       Price charged per unit of a good or service.    
L_QUANTITY_INVOICED NUMBER       Quantity invoiced. Quantity of items for matched invoice lines, price corrections, quantity corrections or unmatched invoice lines    
L_UNIT_MEAS_LOOKUP_CODE VARCHAR2 32     Unit of measure for QUANTITY_INVOICED. Validated against INV_UNITS_OF_MEASURE.UNIT_OF_MEASURE    
H_INVOICE_ID NUMBER 38 0   Invoice identifier.    
H_ACCTS_PAY_CODE_COMBINATION_ID NUMBER 38 0   Accounting Flexfield identifier for accounts payable liability account DW_GL_CODE_COMBINATION_D CODE_COMBINATION_ID
H_APPROVAL_STATUS VARCHAR2 32     Status of manual authorization invoice approval (used for reference purposes only).    
H_CANCELLED_DATE DATE       Date when the invoice was canceled.    
H_CREATED_BY VARCHAR2 64     Who column: indicates the user who created the row.    
H_CREATION_DATE TIMESTAMP       Who column: indicates the date and time of the creation of the row.    
H_DESCRIPTION VARCHAR2 256     Statement that describes the invoice.    
H_DOC_SEQUENCE_VALUE NUMBER       Voucher number (Sequential Numbering) for invoice    
H_EXCHANGE_RATE NUMBER       Ratio at which the principal unit of one currency is converted into another currency for an invoice.    
H_GL_DATE DATE       Accounting date to default to invoice distributions    
H_INVOICE_AMOUNT NUMBER       Invoice amount in transaction currency.    
H_INVOICE_CURRENCY_CODE VARCHAR2 16     Currency code used on the invoice.    
H_INVOICE_DATE DATE       Date when an event will occur or occurred.    
H_INVOICE_NUM VARCHAR2 64     Unique number for supplier invoice.    
H_INVOICE_RECEIVED_DATE DATE       Date when the invoice was received. This is used to calculate when the invoice is due.    
H_INVOICE_TYPE_LOOKUP_CODE VARCHAR2 32     Invoice type. Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=INVOICE TYPE. Possible values are STANDARD, CREDIT, DEBIT, PAYMENT REQUEST, PREPAYMENT, INTEREST, INVOICE REQUEST, AWT, CREDIT MEMO REQUEST, EXPENSE REPORT, MIXED, and so on. DW_CODE_VALUES_LKP_TL CODE
H_LAST_UPDATE_DATE TIMESTAMP       Indicates the date and time of the last update of the row.    
H_LAST_UPDATED_BY VARCHAR2 64     Who column: indicates the user who last updated the row.    
H_LEGAL_ENTITY_ID NUMBER 38 0   Legal entity identifier. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
H_ORG_ID NUMBER 38 0   Business Unit Identifier DW_INTERNAL_ORG_D ORGANIZATION_ID
H_PARTY_ID NUMBER 38 0   Supplier identifier. DW_PARTY_D PARTY_ID
H_PAYMENT_CURRENCY_CODE VARCHAR2 16     Currency code of payment    
H_PAYMENT_METHOD_CODE VARCHAR2 32     Payment method (Header). Values are from the table DW_CODE_VALUES_LKP_TL with CODE_TYPE=AP_PAYMENT_METHOD_CODE. Possible values are Bills Payable, CHECK, EFT, FUTURE_PAY35, NETTING, WIRE, and so on. DW_CODE_VALUES_LKP_TL CODE
H_PAYMENT_REASON_COMMENTS VARCHAR2 256     Free text field available for entering a reason for the payment    
H_PAYMENT_STATUS_FLAG VARCHAR2 16     Flag that indicates if invoice has been paid (Y, N, or P)    
H_REMIT_TO_SUPPLIER_ID NUMBER 38 0   Third party supplier identifier DW_PARTY_D SUPPLIER_ID
H_ROUTING_ATTRIBUTE1 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
H_ROUTING_ATTRIBUTE2 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
H_ROUTING_ATTRIBUTE3 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
H_ROUTING_ATTRIBUTE4 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
H_ROUTING_ATTRIBUTE5 VARCHAR2 512     Captures additional attributes information that may have been used for routing payables invoice images.    
H_SET_OF_BOOKS_ID NUMBER 38 0   Ledger identifier of the invoice. DW_LEDGER_D LEDGER_ID
H_SOURCE VARCHAR2 32     Feeder system from which an invoice is imported.    
H_TERMS_ID NUMBER 38 0   Payment terms identifier. DW_AP_TERMS_D PAYMENT_TERMS_ID
H_VENDOR_SITE_ID NUMBER 38 0   Physical location of the supplier. DW_SUPPLIER_SITE_D SUPPLIER_SITE_ID
H_WFAPPROVAL_STATUS VARCHAR2 64     Status of invoice in the Invoice Approval Workflow process    
H_BATCH_ID NUMBER 38 0   Unique invoice group identifier.    
H_INV_ACCOUNTING_STATUS_CODE VARCHAR2 32     Derived accounting status    
H_INTERCOMPANY_FLAG VARCHAR2 16     Intercompany flag added to incorporate FUN team's intercompany feature.