This is the entity table for distribution of prepayment application invoice distributions to the recipient invoice distribution.
Module: Payables
PREPAY_APP_DIST_ID
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. |