AP Invoice Interface Table

Name Database Length Precision Not Null
INVOICE_ID NUMBER 18 Yes

INVOICE_NUM VARCHAR2 50
INVOICE_TYPE_LOOKUP_CODE VARCHAR2 25
INVOICE_DATE DATE
PO_NUMBER VARCHAR2 30
VENDOR_ID NUMBER 18
VENDOR_NUM VARCHAR2 30
VENDOR_NAME VARCHAR2 240
VENDOR_SITE_ID NUMBER 18
VENDOR_SITE_CODE VARCHAR2 15
INVOICE_AMOUNT NUMBER
INVOICE_CURRENCY_CODE VARCHAR2 15
EXCHANGE_RATE NUMBER
EXCHANGE_RATE_TYPE VARCHAR2 30
EXCHANGE_DATE DATE
TERMS_ID NUMBER 18
TERMS_NAME VARCHAR2 50
DESCRIPTION VARCHAR2 240
AWT_GROUP_ID NUMBER 18
AWT_GROUP_NAME VARCHAR2 25
LAST_UPDATE_DATE TIMESTAMP Yes
LAST_UPDATED_BY VARCHAR2 64 Yes
LAST_UPDATE_LOGIN VARCHAR2 32
CREATION_DATE TIMESTAMP Yes
CREATED_BY VARCHAR2 64 Yes
ATTRIBUTE_CATEGORY VARCHAR2 150
ATTRIBUTE1 VARCHAR2 150
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150
GLOBAL_ATTRIBUTE1 VARCHAR2 150
GLOBAL_ATTRIBUTE_NUMBER1 NUMBER
GLOBAL_ATTRIBUTE_DATE1 DATE
ATTRIBUTE_NUMBER1 NUMBER
ATTRIBUTE_DATE1 DATE
STATUS VARCHAR2 25
SOURCE VARCHAR2 80
GROUP_ID VARCHAR2 80
REQUEST_ID NUMBER
PAYMENT_CROSS_RATE_TYPE VARCHAR2 30
PAYMENT_CROSS_RATE_DATE DATE
PAYMENT_CROSS_RATE NUMBER
PAYMENT_CURRENCY_CODE VARCHAR2 15
WORKFLOW_FLAG VARCHAR2 1
DOC_CATEGORY_CODE VARCHAR2 30
VOUCHER_NUM VARCHAR2 50
PAYMENT_METHOD_LOOKUP_CODE VARCHAR2 25
PAY_GROUP_LOOKUP_CODE VARCHAR2 25
GOODS_RECEIVED_DATE DATE
INVOICE_RECEIVED_DATE DATE
GL_DATE DATE
ACCTS_PAY_CODE_COMBINATION_ID NUMBER 18
USSGL_TRANSACTION_CODE VARCHAR2 30
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 1
ORG_ID NUMBER 18
AMOUNT_APPLICABLE_TO_DISCOUNT NUMBER
PREPAY_NUM VARCHAR2 50
PREPAY_APPLY_AMOUNT NUMBER
PREPAY_GL_DATE DATE
INVOICE_INCLUDES_PREPAY_FLAG VARCHAR2 1
NO_XRATE_BASE_AMOUNT NUMBER
VENDOR_EMAIL_ADDRESS VARCHAR2 2000
TERMS_DATE DATE
REQUESTER_ID NUMBER 18
SHIP_TO_LOCATION VARCHAR2 40
EXTERNAL_DOC_REF VARCHAR2 240
PREPAY_LINE_NUM NUMBER
REQUESTER_FIRST_NAME VARCHAR2 150
REQUESTER_LAST_NAME VARCHAR2 150
APPLICATION_ID NUMBER 18
PRODUCT_TABLE VARCHAR2 30
REFERENCE_KEY1 VARCHAR2 150
APPLY_ADVANCES_FLAG VARCHAR2 1
CALC_TAX_DURING_IMPORT_FLAG VARCHAR2 1
CONTROL_AMOUNT NUMBER
ADD_TAX_TO_INV_AMT_FLAG VARCHAR2 1
TAX_RELATED_INVOICE_ID NUMBER 18
TAXATION_COUNTRY VARCHAR2 30
DOCUMENT_SUB_TYPE VARCHAR2 240
SUPPLIER_TAX_INVOICE_NUMBER VARCHAR2 150
SUPPLIER_TAX_INVOICE_DATE DATE
SUPPLIER_TAX_EXCHANGE_RATE NUMBER
TAX_INVOICE_RECORDING_DATE DATE
TAX_INVOICE_INTERNAL_SEQ VARCHAR2 150
LEGAL_ENTITY_ID NUMBER 18
LEGAL_ENTITY_NAME VARCHAR2 50
REFERENCE_1 VARCHAR2 30
REFERENCE_2 VARCHAR2 30
OPERATING_UNIT VARCHAR2 240
BANK_CHARGE_BEARER VARCHAR2 30
REMITTANCE_MESSAGE1 VARCHAR2 150
UNIQUE_REMITTANCE_IDENTIFIER VARCHAR2 30
URI_CHECK_DIGIT VARCHAR2 2
SETTLEMENT_PRIORITY VARCHAR2 30
PAYMENT_REASON_CODE VARCHAR2 30
PAYMENT_REASON_COMMENTS VARCHAR2 240
PAYMENT_METHOD_CODE VARCHAR2 30
DELIVERY_CHANNEL_CODE VARCHAR2 30
PAID_ON_BEHALF_EMPLOYEE_ID NUMBER 18
NET_OF_RETAINAGE_FLAG VARCHAR2 1
REQUESTER_EMPLOYEE_NUM VARCHAR2 30
CUST_REGISTRATION_CODE VARCHAR2 30
CUST_REGISTRATION_NUMBER VARCHAR2 30
PARTY_ID NUMBER 18
PARTY_SITE_ID NUMBER 18
PAY_PROC_TRXN_TYPE_CODE VARCHAR2 30
PAYMENT_FUNCTION VARCHAR2 30
PAYMENT_PRIORITY NUMBER 2
PORT_OF_ENTRY_CODE VARCHAR2 30
EXTERNAL_BANK_ACCOUNT_ID NUMBER 18
ACCTS_PAY_CODE_CONCATENATED VARCHAR2 250
IMPORT_DOCUMENT_NUMBER VARCHAR2 50
IMPORT_DOCUMENT_DATE DATE
CORRECTION_YEAR NUMBER
CORRECTION_PERIOD VARCHAR2 15
OBJECT_VERSION_NUMBER NUMBER 9 Yes
EMPLOYEE_ADDRESS_CODE VARCHAR2 15
INTERCOMPANY_FLAG VARCHAR2 1
BUDGET_DATE DATE
FIRST_PARTY_REGISTRATION_ID NUMBER 18
THIRD_PARTY_REGISTRATION_ID NUMBER 18
FIRST_PARTY_REGISTRATION_NUM VARCHAR2 60
THIRD_PARTY_REGISTRATION_NUM VARCHAR2 60
LOAD_REQUEST_ID NUMBER 18 Yes
CHECK_VAT_AMOUNT_PAID VARCHAR2 1
TRANSACTION_DEADLINE NUMBER
AUTOMATIC_MATCHING_FLAG VARCHAR2 1
MATCHING_RULE_SET VARCHAR2 50
MATCHING_RULE_SET_ID NUMBER 18
ROUTING_ATTRIBUTE1 VARCHAR2 270
IMAGE_DOCUMENT_NUM VARCHAR2 50
IMAGE_DOCUMENT_URI VARCHAR2 255
FISCAL_DOC_ACCESS_KEY VARCHAR2 50
REMIT_TO_SUPPLIER_NAME VARCHAR2 240
REMIT_TO_SUPPLIER_ID NUMBER 18
REMIT_TO_ADDRESS_NAME VARCHAR2 240
REMIT_TO_ADDRESS_ID NUMBER 18
RELATIONSHIP_ID NUMBER 18
REMIT_TO_SUPPLIER_NUM VARCHAR2 30
Comments
Invoice identifier. Must be unique.
Supplier invoice number. Validation: must be unique for the supplier site.
Type of invoice. Use the Manage Payables Lookups task, lookup type INVOICE TYPE to identify valid values.
Invoice date used to calculate due date per payment terms. Date format: YYYY/MM/DD.
Document number used to request a seller supply a product or service for payment. Use the Manage Purchase Orders task to
Supplier identifier. If the identifier is not available, use the VENDOR_NAME column. Validated against POZ_SUPPLIERS.VENDO
Unique number to identify a supplier. Use the Manage Suppliers task to identify valid values.
Supplier name. Use the Manage Suppliers task to identify valid values.
Supplier site identifier. If the identifier is not available, use the VENDOR_SITE_CODE column. Validated against POZ_SUPPLIER
Physical location of the supplier. Use the Manage Suppliers task to identify valid values.
Invoice amount in transaction currency. Should be positive for standard and prepayment invoices. Should be negative for cred
Currency of invoice. Use the Manage Currencies task to identify valid values. Use the three character ISO currency code. Exam
Exchange rate used for foreign currency invoices. User entered conversion rate. Not validated.
Exchange rate type for foreign currency invoices. Use the Manage Conversion Rate Types task to identify valid values. Validate
Date exchange rate is effective. Usually the accounting date of the transaction. Date format: YYYY/MM/DD.
Payment terms identifier. If the identifier is not available, use the TERMS_NAME column. Validated against AP_TERMS_TL.TER
Name of payment term for an invoice. Use the Manage Payment Terms task to identify valid values.
Invoice description. Free text field. Not validated.
Withholding tax group identifier. If the identifier is not available, use the AWT_GROUP_NAME column. Validated against AP_A
Used to apply multiple withholding taxes to an invoice line. Use the Manage Withholding Groups task to identify valid values.
Who column: indicates the date and time of the last update of the row.
Who column: indicates the user who last updated the row.
Who column: indicates the session login of the user who last updated the row.
Who column: indicates the date and time of the creation of the row.
Who column: indicates the user who created the row.
Descriptive Flexfield: structure definition of the user descriptive flexfield.
Descriptive Flexfield: segment of the user descriptive flexfield.
Global Descriptive Flexfield: structure definition of the global descriptive flexfield.
Global Descriptive Flexfield: segment of the global descriptive flexfield.
Status of import data. Valid values: NEW, NULL.
Feeder system from which invoice is imported. Use the Manage Payables Lookups task, lookup type SOURCE to identify valid v
Value used to select invoices for importing. Free text field. Not validated.
Oracle Enterprise Scheduler: request identifier of the job that created or last updated the row.
Oracle internal use only.
Sequential numbering (voucher number) document category. Use the Manage Payables Document Sequences task to identify
Unique internal identifier assigned to a document. Required if document category code has assignment type of manual.
Name of payment method. Use the Manage Payables Lookups task, lookup type PAYMENT METHOD to identify valid values.
Groups suppliers or invoices for a single pay run. Examples: employees, merchandise, nonmerchandise. Use the Manage Payab
Date when goods on the invoice were received. Date format: YYYY/MM/DD. Required if the terms date basis is Goods Receive
Date when the invoice was received. Also known as terms date. Date format: YYYY/MM/DD. Required if the terms date basis i
Default accounting date for invoice distributions. Date format: YYYY/MM/DD. The date must be in an open or future open acc
Accounting Flexfield identifier for accounts payable liability account. If the identifier is not available, use the ACCTS_PAY_COD
Indicates whether to pay invoice on a separate payment document. Valid values: Y,N, NULL.
Identifier of the business unit associated with the row. If the identifier is not available, use the OPERATING_UNIT column.
Amount of invoice applicable to a discount. Not validated.
Invoice number of an existing, fully paid prepayment for the same supplier site to be applied to the invoice. Validations: settle
Amount of prepayment to apply to the invoice. Must be positive. Cannot exceed the unpaid invoice amount or the amount of
Accounting date for the prepayment application. If NULL, the value for the column GL_DATE is used. Date format: YYYY/MM/D
Prepayment included in invoice amount. Valid values: Y,N, NULL.
Invoice amount in the functional currency. Used to calculate exchange rate. Used only when Calculate User Exchange Rate opti
Supplier e-mail address for XML invoice rejections.
Used with payment terms to calculate scheduled payment of an invoice. Date format: YYYY/MM/DD.
Requester of invoice: used by the Invoice Approval workflow process to generate the list of approvers. If the identifier is not a
Ship to location for purchase order matching. Used for XML invoices. Use the Manage Locations task to identify valid values.
Internal document reference number from Accounts Receivables system. Used for XML invoices.
The invoice line of an existing prepayment to be applied to the invoice.
The first name of the employee who requested goods or services on the invoice line. Both REQUESTER_FIRST_NAME and REQ
The last name of the employee who requested goods or services on the invoice line. . Both REQUESTER_FIRST_NAME and REQ
Oracle internal use only. For Oracle Fusion applications interfacing to Oracle Fusion Payables.
Name of the product source table used to generate an invoice. Free text field. Not validated.
Captures invoice reference information from non-Oracle application. Free text field. Not validated.
Indicates applicable advances will be applied against expense reports and other invoices. Valid values: Y, N, NULL.
Indicates whether tax should be calculated for the invoice during import. Valid values: Y,N, NULL.
Total tax amount. Cannot be more than the invoice amount.
Indicates whether the invoice amount should be grossed up by the calculated tax. Valid values: Y, N, NULL.
Sets the context for tax drivers such as Product Classification Code. If no value is entered, it will display the legal entity country
A document type required by a tax or governmental authority.
The invoice number used to report on a supplier issued tax invoice that is distinct from the regular invoice. Free text field. Not
Tax invoice date on the supplier-issued tax invoice. Date format: YYYY/MM/DD.
Supplier conversion rate entered in online invoices to calculate the supplier tax amount for foreign currency invoices.
If company-specific tax invoice date and number is captured, the date the company receives or records the supplier-issued tax
Company-specific tax invoice number, in sequence, issued by the company for a supplier-issued tax invoice. Free text field. No
Unique identifier of the legal entity. If the identifier is not available, use the LEGAL_ENTITY_NAME column.
Name of the legal entity on the invoice. Use the Manage Legal Entities task to identify valid values.
Captures invoice reference information from a non-Oracle application. Free text field. Not validated.
Captures invoice reference information from a non-Oracle application. Free text field. Not validated.
Business unit to which the invoice refers.
Bearer of bank charge cost. Uses the Manage Payables Lookup task, lookup type BANK BEARER CHARGE to identify valid value
Remittance message for use in payment processing. Free text field. Not validated.
Unique remittance identifier provided by the payee. Not validated.
Unique remittance identifier check digit. Free text field. Not validated.
Priority to settle payment for the transaction. Use the Manage Payables Lookups task, lookup type IBY_SETTLEMENT_PRIORIT
Code to provide the payment system or bank with additional details for the payment. Use the Manage Payment Codes task to
Reason for the payment. Free text field. Not validated.
Payment method, such as check, cash, or credit. Use the Manage Payment Methods task to identify valid values.
Information displayed for an electronic payment that instruct the bank about carrying out the payment. Example: print a chec
Oracle internal use only. Original expense report''s employee identifier when expense report is split using Both Pay Scenario.
Customer legal registration code. Used to derive customer registration number for invoice. Use the Manage Suppliers task, Tra
Customer legal registration number. Used to derive customer registration number for invoice header. Use the Manage Supplie
Oracle internal use only. Unique party identifier derived from supplier or populated by Oracle Fusion applications using Oracle
Oracle internal use only. Unique party site identifier derived from supplier site or populated by Oracle Fusion applications usin
Oracle internal use only. Type of payment processing transaction or document.
Oracle internal use only. The function or purpose of the payment.
The payment priority of a scheduled payment. Valid values: whole numbers from 1 to 99.
Identifies the location or port through which the invoiced goods entered the country. Free text field. Not validated.
External bank account identifier. Defaulted from supplier setup. Do not populate during interface.
Accounting flexfield value for the accounts payable liability account. Validated against the accounting key flexfield values. Use
Customer assigned document number. Not validated.
Customer assigned date during import of invoice. Date format: YYYY/MM/DD.
Correction year for the invoice. Valid format: four numbers. Example: 2010.
Correction period for the invoice being corrected. Not validated.
Used to implement optimistic locking. This number is increased every time the row is updated. The number is compared at the
Address code for employee. Valid values: HOME, OFFICE.
Budgetary Calendar Period Date applicable for funds check
First party tax registration identifier.
Third party tax registration identifier.
First party tax registration number.
Third party tax registration number.
Oracle Enterprise Scheduler: request identifier of the interface load job that created the row.
Indicator used to determine if a partially paid purchase transaction is reportable for tax. Used for tax reporting in eastern and
Number of days to perform an intra-EU transaction. Used for Modelo reports for Spain.
Indicates if automatic matching is enabled for the invoice.
Matching rule set used to perform automatic matching for the invoice.
Matching rule set identifier used to perform automatic matching for the invoice.
Captures additional attributes that can be used for routing payables invoice images.
Fiscal document unique identifier, which is generated by concatenating multiple attributes of fiscal document.
Third party supplier
Third party supplier identifier
Remit-to address where the payment should be sent
Remit-to address identifier where the payment should be sent
Third party relationship identifier
Third party supplier number
Flexfield Mapping
Invoice Gateway Header (AP_INVOICES_INTERFACE)

t be fully applied.

AP Invoice Interface Table

Uploaded by

Copyright:

Available Formats

AP Invoice Interface Table

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

AP Invoice Interface Table

Uploaded by

Copyright:

Available Formats

What are descriptive flexfields and what are they used for?

What is the difference between user and global descriptive flexfields?

Name Database Length Precision Not Null

INVOICE_ID NUMBER 18 Yes

Invoice Gateway Header (AP_INVOICES_INTERFACE)

You might also like