Columns | Data Type | Description | CCB Table | Column | Data Type | Remarks |
|---|---|---|---|---|---|---|
INVOICE_ID | Number | Invoice identifier | AP_INVOICES_interface_S.nextval | |||
INVOICE_NUM | VARCHAR2 (50) | Invoice number | CI_ADJ | ADJ_ID | CHAR (12) | |
INVOICE_TYPE_LOOKUP_CODE | VARCHAR2 (25) | Type of Invoice (can be STANDARD or CREDIT) | ‘STANDARD’ | |||
INVOICE_DATE | DATE | Invoice date | CI_ADJ | CRE_DT | DATE | |
PO_NUMBER | VARCHAR2 (20) | Purchase order number | Leave blank | |||
VENDOR_ID | NUMBER (15) | Supplier identifier. Validated against PO_VENDORS.VENDOR_ID | Example Value =40182 Set to the ID of the vendor created by this integration point. | |||
VENDOR_NUM | VARCHAR2 (30) | Supplier number | Leave blank | |||
VENDOR_NAME | VARCHAR2 (240) | Supplier name | Leave blank | |||
VENDOR_SITE_ID | NUMBER (15,0) | Supplier site identifier. Validated against PO_VENDOR_SITES_ALL.VENDOR_SITE_ID | Example Value =7004 Set to the ID of the vendor site created by this integration point. | |||
VENDOR_SITE_CODE | VARCHAR2 (15) | Supplier site code | ||||
INVOICE_AMOUNT | NUMBER | Invoice amount | CI_ADJ | ADJ_AMT | Number (15,2) | |
INVOICE_CURRENCY_CODE | VARCHAR2 (15) | Currency of invoice. Validated against FND_CURRENCIES.CURRENCY_CODE | Leave blank | |||
EXCHANGE_RATE | NUMBER | Exchange rate for foreign currency invoices | ||||
EXCHANGE_RATE_TYPE | VARCHAR2 (30) | Exchange rate type for foreign currency invoices. Validated against GL_DAILY_CONVERSION_TYPES.CONVERSION_TYPE | ||||
EXCHANGE_DATE | DATE | Date exchange rate is effective, usually accounting date of a transaction | ||||
TERMS_ID | NUMBER (15,0) | Payment terms identifier. Validated against AP_TERMS_TL.TERM_ID | This will come from CCB’s configuration, keep the appropriate terms_id in CCB. | |||
TERMS_NAME | VARCHAR2 (50) | Payment terms name | Leave blank | |||
DESCRIPTION | VARCHAR2 (240) | Invoice description | CI_ADJ_APREQ | ENTITY_NAME|CITY|COUNTRY|ADDRESS1|COUNTY| STATE| POSTAL | VARCHAR2 (240) | |
AWT_GROUP_ID | NUMBER (15,0) | Withholding tax group identifier. Validated against AP_AWT_GROUPS.AWT_GROUP_ID | ||||
AWT_GROUP_NAME | VARCHAR2 (25) | Withholding tax group name | ||||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | Sysdate | |||
LAST_UPDATED_BY | NUMBER (15,0) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | Leave blank | |||
LAST_UPDATE_LOGIN | NUMBER (15,0) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | Leave blank | |||
CREATION_DATE | DATE | Standard who column - date when this row was created | Sysdate | |||
CREATED_BY | NUMBER (15,0) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | Leave blank | |||
ATTRIBUTE_CATEGORY | VARCHAR2 (150) | Descriptive flexfield structure definition column. | Leave blank | |||
ATTRIBUTE1 | VARCHAR2 (150) | Descriptive flexfield segment | Leave blank | |||
ATTRIBUTE2 | VARCHAR2 (150) | |||||
ATTRIBUTE3 | VARCHAR2 (150) | |||||
ATTRIBUTE4 | VARCHAR2 (150) | |||||
ATTRIBUTE5 | VARCHAR2 (150) | |||||
ATTRIBUTE6 | VARCHAR2 (150) | |||||
ATTRIBUTE7 | VARCHAR2 (150) | |||||
ATTRIBUTE8 | VARCHAR2 (150) | |||||
ATTRIBUTE9 | VARCHAR2 (150) | |||||
ATTRIBUTE10 | VARCHAR2 (150) | |||||
ATTRIBUTE11 | VARCHAR2 (150) | |||||
ATTRIBUTE12 | VARCHAR2 (150) | |||||
ATTRIBUTE13 | VARCHAR2 (150) | |||||
ATTRIBUTE14 | VARCHAR2 (150) | |||||
ATTRIBUTE15 (Release 11.5.10) | VARCHAR2 (150) | CI_ADJ_APREQ. AP_REQ_ID | ||||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 (150) | Reserved for country-specific functionality | Leave blank | |||
GLOBAL_ATTRIBUTE1 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE2 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE3 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE4 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE5 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE6 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE7 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE8 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE9 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE10 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE11 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE12 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE13 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE14 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE15 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE16 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE17 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE18 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE19 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE20 | VARCHAR2 (150) | |||||
STATUS | VARCHAR2 (25) | Status of the data in or after the Payables Open Interface Import | Import Process inserts Value = PROCESSED/REJECTED | |||
SOURCE | VARCHAR2 (80) | Prepayment Reference | Derived from BPEL Value = ‘CCB’ | |||
GROUP_ID | VARCHAR2 (80) | Group identifier | Leave blank | |||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request ID of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||||
PAYMENT_CROSS_RATE_TYPE | VARCHAR2 (30) | Cross currency payment rate type (must be EMU Fixed in Release 11) | ||||
PAYMENT_CROSS_RATE_DATE | DATE | Cross currency payment rate date | ||||
PAYMENT_CROSS_RATE | NUMBER | Exchange rate between invoice and payment; in Release 11 the value is always 1 unless they are associated fixed-rate currencies | ||||
PAYMENT_CURRENCY_CODE | VARCHAR2 (15) | Cross currency payment currency. Validated against FND_CURRENCIES.CURRENCY_CODE | ||||
WORKFLOW_FLAG | VARCHAR2 (1) | Flag that indicates if the Payables Open Interface Workflow must process the record (Y or N) | ||||
DOC_CATEGORY_CODE | VARCHAR2 (30) | Sequential numbering (voucher number) document category. Validated against FND_DOC_SEQUENCE_CATEGORIES.CODE | ||||
VOUCHER_NUM | VARCHAR2 (50) | Voucher number; validated (Sequential Numbering enabled), or non-validated (Sequential Numbering not enabled) | ||||
PAYMENT_METHOD_LOOKUP_CODE | VARCHAR2 (25) | Name of payment method | ||||
PAY_GROUP_LOOKUP_CODE | VARCHAR2 (25) | Name of pay group | ||||
GOODS_RECEIVED_DATE | DATE | Date invoice items received | ||||
INVOICE_RECEIVED_DATE | DATE | Date invoice received | ||||
GL_DATE | DATE | Accounting date to default to invoice distributions | Derived from BPEL Leave blank | |||
ACCTS_PAY_CODE_COMBINATION_ID | NUMBER (15,0) | Accounting Flexfield identifier for AP liability account. Validated against GL_CODE_COMBINATIONS.CODE_COMBINATION_ID | ||||
USSGL_TRANSACTION_CODE | VARCHAR2 (30) | Default transaction code for creating US Standard GL journal entries (Oracle Public Sector Payables). Validated against GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE | Leave blank | |||
EXCLUSIVE_PAYMENT_FLAG | VARCHAR2 (1) | Flag that indicates whether to pay invoice on a separate payment document | ||||
ORG_ID | NUMBER (15,0) | Organization identifier | CI_CIS_DIV_CHAR | CHAR_VAL | CHAR (16) | The Value Picked from the Mapping existing in the CCB system. |
AMOUNT_APPLICABLE_TO_DISCOUNT | NUMBER | Amount of invoice applicable to a discount | ||||
PREPAY_NUM | VARCHAR2 (50) | The invoice number of an existing, fully paid prepayment to be applied to the imported invoice | ||||
PREPAY_DIST_NUM | NUMBER (15,0) | No longer used | ||||
PREPAY_APPLY_AMOUNT | NUMBER | The amount of prepayment that the user wants to apply to the invoice. This amount has to be positive. | ||||
PREPAY_GL_DATE | DATE | The accounting date to be used for the prepayment application. If left null, the invoices GL_DATE is used | ||||
INVOICE_INCLUDES_PREPAY_FLAG | VARCHAR2 (1) | Prorate Discount | ||||
NO_XRATE_BASE_AMOUNT | NUMBER | Invoice amount in the functional currency. Used only when the Calculate User Exchange Rate option is enabled, and used only for foreign currency invoices when the exchange rate type is User. The system uses this value and the invoice amount to calculate the exchange rate. | Leave blank | |||
VENDOR_EMAIL_ADDRESS | VARCHAR2 (2000) | Supplier e-mail address for XML invoice rejections | ||||
TERMS_DATE | DATE | Date used with payment terms to calculate scheduled payment of an invoice | ||||
REQUESTER_ID | NUMBER (10,0) | Requester of invoice is used by the Invoice Approval Workflow process to generate the list of approvers | ||||
SHIP_TO_LOCATION | VARCHAR2 (40) | Ship to location for purchase order matching. Used for XML invoices | ||||
EXTERNAL_DOC_REF | VARCHAR2 (240) | Internal document reference number from Accounts Receivables system. Used for XML invoices | ||||
PREPAY_LINE_NUM | NUMBER | The invoice line of an existing Prepayment to be applied to the imported invoice | ||||
REQUESTER_FIRST_NAME | VARCHAR2 (150) | The first name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use Invoice Approval Workflow then you can define rules that use the requester ID to generate a hierarchical list of approvers for the line | ||||
REQUESTER_LAST_NAME | VARCHAR2 (150) | The last name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use Invoice Approval Workflow then you can define rules that use the requester ID to generate a hierarchical list of approvers for the line | ||||
APPLICATION_ID | NUMBER (15,0) | Application Identifier | ||||
PRODUCT_TABLE | VARCHAR2 (30) | Product source table name | ||||
REFERENCE_KEY1 | VARCHAR2 (150) | Primary key information that uniquely identifies a record in other products view | ||||
REFERENCE_KEY2 | VARCHAR2 (150) | |||||
REFERENCE_KEY3 | VARCHAR2 (150 | Leave blank | ||||
REFERENCE_KEY4 | VARCHAR2 (150) | |||||
REFERENCE_KEY5 | VARCHAR2 (150) | |||||
APPLY_ADVANCES_FLAG | VARCHAR2 (1) | A value of Y indicates that applicable advances are applied against expense reports and other invoices | ||||
CALC_TAX_DURING_IMPORT_FLAG | VARCHAR2 (1) | Indicates whether tax must be calculated for the imported invoice | ||||
CONTROL_AMOUNT | NUMBER | Allows user to enter total tax amount to be prorated by E-Business Tax | ||||
ADD_TAX_TO_INV_AMT_FLAG | VARCHAR2 (1) | Indicates whether the invoice amount must be grossed up by the calculated tax | ||||
TAX_RELATED_INVOICE_ID | NUMBER (15,0) | Tax Driver: Invoice ID of related document for tax purposes. | ||||
TAXATION_COUNTRY | VARCHAR2 (30) | Replaces a GDFF: This country sets the context for other tax drivers. The value defaults to the LE country but can be overridden by the user | ||||
DOCUMENT_SUB_TYPE | VARCHAR2 (150) | Replaces a GDFF: In certain countries, a tax or governmental authority defines and classifies document types for reporting purposes | ||||
SUPPLIER_TAX_INVOICE_NUMBER | VARCHAR2 (150) | Replaces a GDFF: In some countries such as Thailand, there is a requirement to report on a supplier issued "tax" invoice that is distinct from the regular invoice. The tax invoice is either attached to the standard Supplier Invoice (when the value = Goods); or, the supplier may issue it when he receives the payment. | ||||
SUPPLIER_TAX_INVOICE_DATE | DATE | Replaces a GDFF: To satisfy reporting requirements in certain countries, the company-issued Tax Invoice Date and Number. This field is used to record the company-specific tax invoice number, in sequence, issued by the company for a supplier-issued tax invoice. This is required to comply with reporting requirements | ||||
SUPPLIER_TAX_EXCHANGE_RATE | NUMBER | Replaces a GDFF: The supplier exchange rate is entered in online invoices to calculate the supplier tax amount for foreign currency invoices. The gain/loss in the tax amount for foreign currency invoices is the difference between the in-house tax amount using the in-house exchange rate and the supplier tax amount using the supplier exchange rate that you enter here. A manual journal entry is posted to the GL to incorporate the gain/loss. | ||||
TAX_INVOICE_RECORDING_DATE | DATE | Replaces a GDFF: To satisfy reporting requirements in certain countries, the company-specific Tax Invoice Date and Number needs to be captured. This field is used to record the date the company receives/ records the supplier-issued tax invoice and is required to comply with reporting requirements. | ||||
TAX_INVOICE_INTERNAL_SEQ | VARCHAR2 (150) | Replaces a GDFF: To satisfy reporting requirements in certain countries, the company-issued Tax Invoice Date and Number. This field is used to record the company-specific tax invoice number, in sequence, issued by the company for a supplier-issued tax invoice. This is required to comply with reporting requirements | ||||
LEGAL_ENTITY_ID | NUMBER (15,0) | Legal Entity Identifier | ||||
LEGAL_ENTITY_NAME | VARCHAR2 (50) | Legal Entity Name | ||||
REFERENCE_1 | VARCHAR2 (30) | A reference to a record in another application | ||||
REFERENCE_2 | VARCHAR2 (30) | A reference to a record in another application | ||||
OPERATING_UNIT | VARCHAR2 (240) | Organization name | ||||
BANK_CHARGE_BEARER | VARCHAR2 (30) | Bearer of bank charge cost. Bank charge bearers are defined as the lookup IBY_BANK_CHARGE_BEARER | ||||
REMITTANCE_MESSAGE1 | VARCHAR2 (150) | Remittance message for use in payment processing | ||||
REMITTANCE_MESSAGE2 | VARCHAR2 (150) | Remittance message for use in payment processing | ||||
REMITTANCE_MESSAGE3 | VARCHAR2 (150) | Remittance message for use in payment processing | ||||
UNIQUE_REMITTANCE_IDENTIFIER | VARCHAR2 (30) | Unique remittance identifier provided by the payee | ||||
URI_CHECK_DIGIT | VARCHAR2 (2) | Unique remittance identifier check digit | Leave blank | |||
SETTLEMENT_PRIORITY | VARCHAR2 (30) | The priority with which the financial institution or payment system must settle payment for this document. The available values for this column come from the FND lookup IBY_SETTLEMENT_PRIORITY | ||||
PAYMENT_REASON_CODE | VARCHAR2 (30) | Payment reason code | ||||
PAYMENT_REASON_COMMENTS (Release R12) | VARCHAR2 (240) | Free text field available for entering a reason for the payment | CI_ADJ_APREQ | AP_REQ_ID | CHAR (12) | |
PAYMENT_METHOD_CODE (not available for Release 11.5.10) | VARCHAR2 (30) | Payment method identifier | Value = CHECK | |||
DELIVERY_CHANNEL_CODE | VARCHAR2 (30) | Delivery channel code | Leave blank | |||
PAID_ON_BEHALF_EMPLOYEE_ID | NUMBER (15,0) | When an expense report gets split in Both Pay scenario, the new expense report's paid_on_behalf_employee_id gets populated with the original expense report's employee_id | ||||
NET_OF_RETAINAGE_FLAG | VARCHAR2 (1) | Flag to indicate invoice amount is net of retainage | ||||
REQUESTER_EMPLOYEE_NUM | VARCHAR2 (30) | The employee number of the employee who requested goods or services on the invoice line | ||||
CUST_REGISTRATION_CODE | VARCHAR2 (30) | Customer legal registration code | ||||
CUST_REGISTRATION_NUMBER | VARCHAR2 (30) | Customer legal registration number | ||||
PARTY_ID | NUMBER (15,0) | Party identifier | Leave blank | |||
PARTY_SITE_ID | NUMBER (15,0) | Party Site identifier | ||||
PAY_PROC_TRXN_TYPE_CODE | VARCHAR2 (30) | Type of payment processing transaction or document | ||||
PAYMENT_FUNCTION | VARCHAR2 (30) | The function or purpose of the payment | ||||
PAYMENT_PRIORITY | NUMBER (2,0) | Number representing payment priority of a scheduled payment (1 to 99) | ||||
PORT_OF_ENTRY_CODE | VARCHAR2 (30) | Customs location code | ||||
EXTERNAL_BANK_ACCOUNT_ID | NUMBER (15,0) | External bank account identifier | Leave blank | |||
Columns | Data Type | Description | CCB Table | Column | Data Type | Remarks |
|---|---|---|---|---|---|---|
INVOICE_ID | NUMBER (15,0) | Invoice identifier. Validated against AP_INVOICES_INTERFACE.INVOICE_ID | AP_INVOICES_interface_S.currval | |||
INVOICE_LINE_ID | NUMBER (15,0) | Invoice line identifier | AP_INVOICE_lines_interface_S.nextval | |||
LINE_NUMBER | NUMBER (15,0) | Invoice line number | Value =1 | |||
LINE_TYPE_LOOKUP_CODE | VARCHAR2 (25) | Type of invoice line (Item, Freight, Tax, Miscellaneous) | 'MISCELLANEOUS' | |||
LINE_GROUP_NUMBER | NUMBER | Value to identify each item line to which you want to prorate | Leave blank | |||
AMOUNT | NUMBER | Line amount | CI_ADJ | ADJ_AMT | Number (15,2) | |
ACCOUNTING_DATE | DATE | Accounting date | SYSDATE | |||
DESCRIPTION | VARCHAR2 (240) | Description | Value =‘Refund Request from Oracle Utilities Customer Care and Billing’ | |||
AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 (1) | No Longer Used | ||||
PRORATE_ACROSS_FLAG | VARCHAR2 (1) | Prorate indicator for this line to be prorated across all lines with the same LINE_GROUP_NUMBER | Leave blank | |||
TAX_CODE | VARCHAR2 (15) | Tax code. Validated against AP_TAX_CODES_ALL.NAME | ||||
FINAL_MATCH_FLAG | VARCHAR2 (1) | Final match indicator for distribution line matched to purchase order | ‘N’, Since we are not matching to PO | |||
PO_HEADER_ID | NUMBER | Purchase order header identifier used for PO matching. Validated against PO_HEADERS_ALL.PO_HEADER_ID | ||||
PO_NUMBER | VARCHAR2 (20) | Purchase order number used for PO matching. Validated against PO_HEADERS_ALL.SEGMENT1 | ||||
PO_LINE_ID | NUMBER | Purchase order line identifier used for PO matching. Validated against PO_LINES_ALL.PO_LINE_ID | ||||
PO_LINE_NUMBER | NUMBER | Purchase order line number used for PO matching. Validated against PO_LINES_ALL.PO_LINE_NUM | ||||
PO_LINE_LOCATION_ID | NUMBER | Purchase order line location identifier used for PO matching. Validated against PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID | ||||
PO_SHIPMENT_NUM | NUMBER | Purchase order shipment number used for PO matching. Validated against PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM | ||||
PO_DISTRIBUTION_ID | NUMBER | Purchase order distribution line identifier used for PO matching. Validated against PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID | Leave blank | |||
PO_DISTRIBUTION_NUM | NUMBER | Purchase order distribution line number used for PO matching. Validated against PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_NUM | ||||
PO_UNIT_OF_MEASURE | VARCHAR2 (25) | No longer used | ||||
INVENTORY_ITEM_ID | NUMBER | Inventory item identifier. Validated against MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID | ||||
ITEM_DESCRIPTION | VARCHAR2 (240) | Inventory item description | ||||
QUANTITY_INVOICED | NUMBER | Quantity invoiced against purchase order shipment | ||||
SHIP_TO_LOCATION_CODE | VARCHAR2 (60) | Ship to location code | ||||
UNIT_PRICE | NUMBER | Unit price for purchase order matched invoice items | ||||
DISTRIBUTION_SET_ID | NUMBER (15,0) | Distribution set identifier. Validated against AP_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_ID | ||||
DISTRIBUTION_SET_NAME | VARCHAR2 (50) | Distribution set name. Validated against AP_INVOICE_DISTRIBUTION_SETS_ALL.DISTRIBUTION_SET_NAME | Leave blank | |||
DIST_CODE_CONCATENATED | VARCHAR2 (250) | Accounting flexfield for account associated with a distribution line | CI_DST_CODE_EFF | GL_ACCT | VARCHAR2 (48) | Extract all the segments that comes from the CCB side and separate them by ‘-‘ |
DIST_CODE_COMBINATION_ID | NUMBER (15,0) | Accounting flexfield identifier for account associated with a distribution line. Validated against GL_CODE_COMBINATIONS.CODE_COMBINATION_ID | ||||
AWT_GROUP_ID | NUMBER (15,0) | Withholding tax group identifier. Validated against AP_AWT_GROUPS.GROUP_ID | ||||
AWT_GROUP_NAME | VARCHAR2 (25) | Withholding tax group name | Leave blank | |||
LAST_UPDATED_BY | NUMBER (15,0) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | ||||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | SYSDATE | |||
LAST_UPDATE_LOGIN | NUMBER (15,0) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | Leave blank | |||
CREATED_BY | NUMBER (15,0) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | Leave blank | |||
CREATION_DATE | DATE | Standard who column - date when this row was created | SYSDATE | |||
ATTRIBUTE_CATEGORY | VARCHAR2 (150) | Descriptive flexfield structure definition column. | Leave blank | |||
ATTRIBUTE1 | VARCHAR2 (150) | Descriptive flexfield segment | Leave blank | |||
ATTRIBUTE2 | VARCHAR2 (150) | |||||
ATTRIBUTE3 | VARCHAR2 (150) | |||||
ATTRIBUTE4 | VARCHAR2 (150) | |||||
ATTRIBUTE5 | VARCHAR2 (150) | |||||
ATTRIBUTE6 | VARCHAR2 (150) | |||||
ATTRIBUTE7 | VARCHAR2 (150) | |||||
ATTRIBUTE8 | VARCHAR2 (150) | |||||
ATTRIBUTE9 | VARCHAR2 (150) | |||||
ATTRIBUTE10 | VARCHAR2 (150) | |||||
ATTRIBUTE11 | VARCHAR2 (150) | |||||
ATTRIBUTE12 | VARCHAR2 (150) | |||||
ATTRIBUTE13 | VARCHAR2 (150) | |||||
ATTRIBUTE14 | VARCHAR2 (150) | |||||
ATTRIBUTE15 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE1 | VARCHAR2 (150) | Reserved for country-specific localizations | Leave blank | |||
GLOBAL_ATTRIBUTE2 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE3 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE4 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE5 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE6 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE7 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE8 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE9 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE10 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE11 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE12 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE13 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE14 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE15 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE16 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE17 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE18 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE19 | VARCHAR2 (150) | |||||
GLOBAL_ATTRIBUTE20 | VARCHAR2 (150) | |||||
PO_RELEASE_ID | NUMBER | Blanket purchase order release identifier used for PO matching. Validated against PO_RELEASES_ALL.PO_RELEASE_ID | Leave blank | |||
RELEASE_NUM | NUMBER | Blanket purchase order release number used for PO matching. Validated against PO_RELEASES_ALL.RELEASE_NUM | ||||
ACCOUNT_SEGMENT | VARCHAR2 (25) | Value for account segment of accounting flexfield. Payables overlays this value on the accounting flexfield during import | ||||
BALANCING_SEGMENT | VARCHAR2 (25) | Value for balancing segment of accounting flexfield. Payables overlays this value on the accounting flexfield during import | ||||
COST_CENTER_SEGMENT | VARCHAR2 (25) | Value for cost center segment of accounting flexfield. Payables overlay this value on the accounting flexfield during import | ||||
PROJECT_ID | NUMBER (15,0) | Identifier for project used to build default accounting flexfield. Validated against PA_PROJECTS_ALL.PROJECT_ID | ||||
TASK_ID | NUMBER (15,0) | Identifier for project task used to build default accounting flexfield. Validated against PA_TASKS.TASK_ID | ||||
EXPENDITURE_TYPE | VARCHAR2 (30) | Project expenditure type used to build default accounting flexfield. Validated against PA_EXPENDITURE_TYPES.EXPENDITURE_TYPE | ||||
EXPENDITURE_ITEM_DATE | DATE | Project expenditure item date used to build default accounting flexfield | ||||
EXPENDITURE_ORGANIZATION_ID | NUMBER (15,0) | Identifier for project organization used to build default accounting flexfield. Validated against PA_EXP_ORGS_IT.ORGANIZATION_ID | ||||
PROJECT_ACCOUNTING_CONTEXT | VARCHAR2 (30) | No longer used | ||||
PA_ADDITION_FLAG | VARCHAR2 (1) | Flag that indicates if project related invoice distributions have been transferred into Oracle Projects (Y or N) | ||||
PA_QUANTITY | NUMBER (22,5) | Project item quantity used to build accounting flexfield for project-related distribution line | Leave blank | |||
USSGL_TRANSACTION_CODE | VARCHAR2 (30) | USSGL transaction code for creating US Standard GL journal entries (Oracle Public Sector Payables). Validated against GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE | ||||
STAT_AMOUNT | NUMBER | Amount associated with a distribution line for measuring statistical quantities | ||||
TYPE_1099 | VARCHAR2 (10) | 1099 type | ||||
INCOME_TAX_REGION | VARCHAR2 (10) | Reporting region for distribution line for 1099 supplier. Validated against AP_INCOME_TAX_REGIONS.REGION_SHORT_NAME | ||||
ASSETS_TRACKING_FLAG | VARCHAR2 (1) | Flag that indicates if distribution line is tracked in Oracle Assets (Y or N) | ||||
PRICE_CORRECTION_FLAG | VARCHAR2 (1) | Flag that indicates if line produces price correction | ||||
ORG_ID | NUMBER (15,0) | Organization identifier | ||||
RECEIPT_NUMBER | VARCHAR2 (30) | The receipt number to which an invoice is matched. Validated against RCV_SHIPMENT_HEADERS.RECEIPT_NUM | ||||
RECEIPT_LINE_NUMBER | VARCHAR2 (25) | The receipt line number to which an invoice is matched. Validated against RCV_SHIPMENT_LINES.LINE_NUM | ||||
MATCH_OPTION | VARCHAR2 (25) | The value of the Invoice Match option on the PO shipment | ||||
PACKING_SLIP | VARCHAR2 (25) | Packing slip identifier | ||||
RCV_TRANSACTION_ID | NUMBER | Receipt identifier used for Receipt matching. Validated against RCV_TRANSACTIONS.TRANSACTION_ID | ||||
PA_CC_AR_INVOICE_ID | NUMBER (15,0) | Identifier of the corresponding receivable intercompany invoice in Oracle Receivables | ||||
PA_CC_AR_INVOICE_LINE_NUM | NUMBER (15,0) | Line number of the corresponding receivable intercompany invoice in Oracle Receivables | ||||
REFERENCE_1 | VARCHAR2 (30) | A reference to a record in another application | CI_ADJ_APREQ | AP_REQ_ID | CHAR (12) | |
REFERENCE_2 | VARCHAR2 (30) | A reference to a record in another application | ||||
PA_CC_PROCESSED_CODE | VARCHAR2 (1) | Indicates the processing status of this invoice line by Oracle Projects in the Receiver Operating Unit | ||||
TAX_RECOVERY_RATE | NUMBER | No Longer Used | Leave blank | |||
TAX_RECOVERY_OVERRIDE_FLAG | VARCHAR2 (1) | No Longer Used | Leave blank | |||
TAX_RECOVERABLE_FLAG | VARCHAR2 (1) | No Longer Used | ||||
TAX_CODE_OVERRIDE_FLAG | VARCHAR2 (1) | No Longer Used | ||||
TAX_CODE_ID | NUMBER (15,0) | Tax code identifier for the tax code to be used. Validated against AP_TAX_CODES_ALL.TAX_ID | ||||
CREDIT_CARD_TRX_ID | NUMBER (15,0) | Credit card transaction ID if the line is a credit card charge | ||||
AWARD_ID | NUMBER (15,0) | Grants requirement to store award | ||||
VENDOR_ITEM_NUM | VARCHAR2 (25) | Optional. Validated against PO_LINES_ALL.VENDOR_PRODUCT_NUM | ||||
TAXABLE_FLAG | VARCHAR2 (1) | A value of Y indicates that the line is taxable | ||||
PRICE_CORRECT_INV_NUM | VARCHAR2 (50) | Number of the invoice that this price correction invoice is correcting. Validated against AP_INVOICES_ALL.INVOICE_NUM | ||||
EXTERNAL_DOC_LINE_REF | VARCHAR2 (240) | Internal document reference number from Accounts Receivables system. Used for XML invoices | ||||
SERIAL_NUMBER | VARCHAR2 (35) | Serial number for item | ||||
MANUFACTURER | VARCHAR2 (30) | Name of the manufacturer | ||||
MODEL_NUMBER | VARCHAR2 (40) | Model information | ||||
WARRANTY_NUMBER | VARCHAR2 (15) | Warranty number | ||||
DEFERRED_ACCTG_FLAG | VARCHAR2 (1) | Flag that indicates whether to generate deferred accounting for this line | ||||
DEF_ACCTG_START_DATE | DATE | The start date of the deferred expense period | ||||
DEF_ACCTG_END_DATE | DATE | The end date of the deferred expense period | ||||
DEF_ACCTG_NUMBER_OF_PERIODS | NUMBER | Number of periods to generate deferred expenses. Used in combination with PERIOD_TYPE. Alternative to END_DATE | ||||
DEF_ACCTG_PERIOD_TYPE | VARCHAR2 (15) | Period type used in combination with NUMBER_OF_PERIODS to generate deferred expenses. Validated against XLA_LOOKUPS with lookup type XLA_DEFERRED_PERIOD_TYPE | ||||
UNIT_OF_MEAS_LOOKUP_CODE | VARCHAR2 (25) | Unit of Measure for quantity invoiced. Validated against MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE | Leave blank | |||
PRICE_CORRECT_INV_LINE_NUM | NUMBER | Invoice line subject to the price correction | ||||
ASSET_BOOK_TYPE_CODE | VARCHAR2 (15) | Asset Book Defaults to the distributions candidate for transfer to Oracle Assets | ||||
ASSET_CATEGORY_ID | NUMBER (15,0) | Asset Category Defaults to the distributions candidate for transfer to Oracle Assets | ||||
REQUESTER_ID | NUMBER (15,0) | Requester identifier. Valid values from active HR employees. Validated against PER_ALL_PEOPLE_F.PERSON_ID | ||||
REQUESTER_FIRST_NAME | VARCHAR2 (150) | The first name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use Invoice Approval Workflow then you can define rules that use the requester ID to generate a hierarchical list of approvers for the line | ||||
REQUESTER_LAST_NAME | VARCHAR2 (150) | The last name of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use Invoice Approval Workflow then you can define rules that use the requester ID to generate a hierarchical list of approvers for the line | ||||
REQUESTER_EMPLOYEE_NUM | VARCHAR2 (30) | The employee number of the employee who requested goods or services on the invoice line. This value is used to derive the requester ID. If you use Invoice Approval Workflow then you can define rules that use the requester ID to generate a hierarchical list of approvers for the line | ||||
APPLICATION_ID | NUMBER (15,0) | Application Identifier | ||||
PRODUCT_TABLE | VARCHAR2 (30) | Product source table name | ||||
REFERENCE_KEY1 | VARCHAR2 (150) | Primary key information that uniquely identifies a record in other products view | ||||
REFERENCE_KEY2 | VARCHAR2 (150) | Primary key information that uniquely identifies a record in other products view | ||||
REFERENCE_KEY3 | VARCHAR2 (150) | Primary key information that uniquely identifies a record in other products view | ||||
REFERENCE_KEY4 | VARCHAR2 (150) | Primary key information that uniquely identifies a record in other products view | ||||
REFERENCE_KEY5 | VARCHAR2 (150) | Primary key information that uniquely identifies a record in other products view | ||||
PURCHASING_CATEGORY | VARCHAR2 (2000) | Item category concatenated segments | ||||
PURCHASING_CATEGORY_ID | NUMBER (15,0) | Item category unique identifier | ||||
COST_FACTOR_ID | NUMBER (15,0) | Identifier of the cost component class. Cost Component Classes are used to identify the individual buckets or component costs that make up the total cost of an item, for example, direct material costs, freight costs, labor costs, production or conversion costs and so on | ||||
COST_FACTOR_NAME | VARCHAR2 (80) | Cost component class name. Cost Component Classes are used to identify the individual buckets or component costs that make up the total cost of an item, for example, direct material costs, freight costs, labor costs, production or conversion costs and so on. | Leave blank | |||
CONTROL_AMOUNT | NUMBER | Optional, user-enterable value to ensure that the calculated tax is the same as on the physical document | ||||
ASSESSABLE_VALUE | NUMBER | User-enterable amount to be used as taxable basis | ||||
DEFAULT_DIST_CCID | NUMBER (15,0) | Already addressed by lines project Tax Driver: Code combination identifier of the GL account associated with the transaction line. Note that this is necessary to support the Account Method VAT feature | ||||
PRIMARY_INTENDED_USE | VARCHAR2 (30) | Tax Driver: The purpose for which a product may be used. The actual use is stored at the distribution level. | ||||
SHIP_TO_LOCATION_ID | NUMBER (15,0) | Tax Driver: Ship to location ID. Value entered by user only if line is not PO matched. | ||||
PRODUCT_TYPE | VARCHAR2 (240) | Tax Driver: Type of product. Possible values are: Goods, Service. This value will default from Inventory Item attributes. Otherwise, value is entered by user. | ||||
PRODUCT_CATEGORY | VARCHAR2 (240) | Tax Driver: Product category | ||||
PRODUCT_FISC_CLASSIFICATION | VARCHAR2 (240) | Tax Driver: Product fiscal classification | ||||
USER_DEFINED_FISC_CLASS | VARCHAR2 (240) | Tax Driver: Fiscal Classification. | ||||
TRX_BUSINESS_CATEGORY | VARCHAR2 (240) | Tax Driver: Transactions category assigned by user. | ||||
TAX_REGIME_CODE | VARCHAR2 (30) | Tax Regime Code: The set of tax rules that determines the treatment of one or more taxes administered by a tax authority. e.g., VAT Regime in Argentina | ||||
TAX | VARCHAR2 (30) | A classification of a charge imposed by a government through a fiscal or tax authority. | ||||
TAX_JURISDICTION_CODE | VARCHAR2 (30) | Internal ID of the Tax Jurisdiction | ||||
TAX_STATUS_CODE | VARCHAR2 (30) | Tax status code. e.g., taxable standard rate, zero rated, exempt, non-taxable | ||||
TAX_RATE_ID | NUMBER (15,0) | Internal identifier for tax rate effective on the invoice date. | ||||
TAX_RATE_CODE | VARCHAR2 (150) | Tax rate name associated with tax rate identifier. Tax_rate_id is unique while a tax_rate_code may have different tax rates based on date ranges | ||||
TAX_RATE | NUMBER | The rate specified for a tax status in effect for a period of time. | ||||
INCL_IN_TAXABLE_LINE_FLAG | VARCHAR2 (1) | Flag to indicate if the amount in the tax line is included or not in the taxable line | Leave blank | |||
SOURCE_APPLICATION_ID | NUMBER | Source document application identifier | ||||
SOURCE_ENTITY_CODE | VARCHAR2 (30) | Source document entity code | ||||
SOURCE_EVENT_CLASS_CODE | VARCHAR2 (30) | Source document event class code | ||||
SOURCE_TRX_ID | NUMBER | Source document transaction identifier | ||||
SOURCE_LINE_ID | NUMBER | Identifier of the lowest level for which Tax is calculated | ||||
SOURCE_TRX_LEVEL_TYPE | VARCHAR2 (30) | Source document transaction level type | ||||
TAX_CLASSIFICATION_CODE | VARCHAR2 (30) | Tax Classification Code | ||||