RA_INTERFACE_LINES_ALL
The RA_INTERFACE_LINES_ALL table stores interface information for each invoice line that AutoInvoice imports into Oracle Receivables. The primary key for this table is INTERFACE_LINE_ID.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
---|---|---|---|---|---|---|
INTERFACE_LINE_ID | NUMBER | 18 | Oracle internal use only. Interface line identifier. | |||
ENF_SEQ_DATE_CORRELATION_CODE | VARCHAR2 | 1 | Option to enforce correlation between the transaction accounting date and the transaction sequence number. Oracle internal use only. | |||
INTERFACE_LINE_CONTEXT | VARCHAR2 | 30 | Context code for Line Transactions descriptive flexfield. Use Manage Receivables Descriptive Flexfields task to identify valid values. Use INTERFACE_LINE_ATTRIBUTE1 to INTERFACE_LINE_ATTRIBUTE15 for the segment values. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE1 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE2 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE3 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE4 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE5 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE6 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE7 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE8 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
BATCH_SOURCE_NAME | VARCHAR2 | 50 | Yes | Batch transaction source. Use the Manage Transaction Sources task to identify valid values. | ||
SET_OF_BOOKS_ID | NUMBER | 18 | Ledger identifier. Use the Manage Primary Ledgers task to find valid ledger identifiers. If left blank, defaults from system options for the business unit. | |||
LINE_TYPE | VARCHAR2 | 20 | Yes | Transaction line type. Valid values: LINE, TAX, FREIGHT, and CHARGES. | ||
DESCRIPTION | VARCHAR2 | 240 | Yes | Transaction line description. Mandatory. Free text field. Not validated. | ||
CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code. Use the Manage Currencies task to identify valid values. Use the three character ISO currency code. Example: US Dollars is USD. | ||
AMOUNT | NUMBER | Transaction line amount. Do not use thousand separators. Use: period (.) or comma (,) as decimal separator. Mandatory if the LINE_TYPE is LINE and the line isn''t only for freight or tax. | ||||
CUST_TRX_TYPE_NAME | VARCHAR2 | 20 | Transaction type name. Use the Manage Transaction Types task to identify valid values. Credit memos must use a credit memo transaction type name. Use either CUST_TRX_TYPE_NAME or CUST_TRX_TYPE_ID, but not both. | |||
CUST_TRX_TYPE_ID | NUMBER | 18 | Transaction type identifier. Use the Manage Transaction Types task to identify valid values. Credit memos must use a credit memo transaction type name. | |||
TERM_NAME | VARCHAR2 | 15 | Payment term name. Use the Manage Receivables Payment Terms task to identify valid values. Use either TERM_NAME or TERM_ID, but not both. Do not use for credit memos or on-account credits. | |||
TERM_ID | NUMBER | 18 | Payment term identifier. Use the Manage Receivables Payment Terms task to find valid values. Use either TERM_NAME or TERM_ID, but not both. Do not use for credit memos or on-account credits. | |||
ORIG_SYSTEM_BATCH_NAME | VARCHAR2 | 40 | Original system batch name for grouping transactions. Free text field. Not validated. | |||
ORIG_SYSTEM_BILL_CUSTOMER_REF | VARCHAR2 | 240 | Original system bill-to customer. Use the Manage Customers taskpane from the Billing work area to identify valid values. Use either ORIG_SYSTEM_BILL_CUSTOMER_ID or ORIG_SYSTEM_BILL_CUSTOMER_REF, but not both. | |||
ORIG_SYSTEM_BILL_CUSTOMER_ID | NUMBER | 18 | Original system bill-to customer identifier. Use either ORIG_SYSTEM_BILL_CUSTOMER_ID or ORIG_SYSTEM_BILL_CUSTOMER_REF, but not both. | |||
ORIG_SYSTEM_BILL_ADDRESS_REF | VARCHAR2 | 240 | Original system bill-to address reference. Use the Manage Customers taskpane from the Billing work area to identify valid values. Use either ORIG_SYSTEM_BILL_ADDRESS_REF or ORIG_SYSTEM_BILL_ADDRESS_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYSTEM_BILL_ADDRESS_ID | NUMBER | 18 | Original system bill-to customer address identifier. Use either ORIG_SYSTEM_BILL_ADDRESS_REF or ORIG_SYSTEM_BILL_ADDRESS_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYSTEM_BILL_CONTACT_REF | VARCHAR2 | 240 | Original system billing contact reference. Use the Manage Customers taskpane in Billing to identify valid values. Use either ORIG_SYSTEM_BILL_CONTACT_REF or ORIG_SYSTEM_BILL_CONTACT_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYSTEM_BILL_CONTACT_ID | NUMBER | 18 | Original system billing contact identifier. Use either ORIG_SYSTEM_BILL_CONTACT_REF or ORIG_SYSTEM_BILL_CONTACT_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYSTEM_SHIP_CUSTOMER_REF | VARCHAR2 | 240 | Original system ship to customer reference. Use either ORIG_SYSTEM_SHIP_CUSTOMER_REF or ORIG_SYSTEM_SHIP_CUSTOMER_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYSTEM_SHIP_CUSTOMER_ID | NUMBER | 18 | Original system ship to customer identifier. Use either ORIG_SHIP_CUSTOMER_ID or ORIG_SYSTEM_SHIP_CUSTOMER_REF, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYSTEM_SHIP_ADDRESS_REF | VARCHAR2 | 240 | Original system shipping address reference. Use either ORIG_SYSTEM_SHIP_ADDRESS_REF or ORIG_SYSTEM_SHIP_ADDRESS_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYSTEM_SHIP_ADDRESS_ID | NUMBER | 18 | Original system ship-to address identifier. Use either ORIG_SYSTEM_SHIP_ADDRESS_REF or ORIG_SYSTEM_SHIP_ADDRESS_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYSTEM_SHIP_CONTACT_REF | VARCHAR2 | 240 | Original system shipping contact reference. Use either ORIG_SYSTEM_SHIP_CONTACT_REF or ORIG_SYSTEM_SHIP_CONTACT_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYSTEM_SHIP_CONTACT_ID | NUMBER | 18 | Original system shipping contact identifier. Use either ORIG_SYSTEM_SHIP_CONTACT_REF or ORIG_SYSTEM_SHIP_CONTACT_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYSTEM_SOLD_CUSTOMER_REF | VARCHAR2 | 240 | Original system sold to customer reference. Use either ORIG_SYSTEM_SOLD_CUSTOMER_REF or ORIG_SYSTEM_SOLD_CUSTOMER_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYSTEM_SOLD_CUSTOMER_ID | NUMBER | 18 | Original system sold to customer identifier. Use either ORIG_SYSTEM_SOLD_CUSTOMER_REF or ORIG_SYSTEM_SOLD_CUSTOMER_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
LINK_TO_LINE_ID | NUMBER | 18 | Oracle internal use only. Link to line identifier. | |||
LINK_TO_LINE_CONTEXT | VARCHAR2 | 30 | Context code for Link-to Transactions descriptive flexfield. Use the Manage Receivables Descriptive Flexfields task to identify valid values. Use LINK_TO_LINE_ATTRIBUTE1 to LINK_TO_LINE_ATTRIBUTE15 for the segment values. | |||
LINK_TO_LINE_ATTRIBUTE1 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
LINK_TO_LINE_ATTRIBUTE2 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
LINK_TO_LINE_ATTRIBUTE3 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
LINK_TO_LINE_ATTRIBUTE4 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
LINK_TO_LINE_ATTRIBUTE5 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
LINK_TO_LINE_ATTRIBUTE6 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
LINK_TO_LINE_ATTRIBUTE7 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
RECEIPT_METHOD_NAME | VARCHAR2 | 30 | Receipt method name. Use Manage Receipt Classes and Methods task to identify valid values. Must be a receipt method associated with the customer. Use either RECEIPT_METHOD_NAME or RECEIPT_METHOD_ID, but not both. | |||
RECEIPT_METHOD_ID | NUMBER | 18 | Receipt method identifier. Use Manage Receipt Classes and Methods task to identify valid values. Must be a receipt method associated with the customer. Use either RECEIPT_METHOD_NAME or RECEIPT_METHOD_ID, but not both. | |||
CONVERSION_TYPE | VARCHAR2 | 30 | Yes | Conversion rate type. Required if CONVERSION_TYPE is User defined or if the line currency code is the same as the ledger currency. Use Manage Conversion Rate Types task to identify valid values. To provide a conversion rate for the line use: User. | ||
CONVERSION_DATE | DATE | Conversion rate date. Date format: RR/MM/DD. If NULL, TRANSACTION_DATE is used as the exchange rate date. Do not use if the CURRENCY_CODE is the same as the ledger currency used to account for the line. | ||||
CONVERSION_RATE | NUMBER | Conversion rate. Required if CURRENCY_CODE value is different than the ledger currency used to account for the line and/or the CONVERSION_TYPE is User. If the CURRENCY_CODE is the same as the ledger currency use: 1.00. | ||||
CUSTOMER_TRX_ID | NUMBER | 18 | Oracle internal use only. Transaction identifier. | |||
TRX_DATE | DATE | Transaction date. Date format: RR/MM/DD. Do not use if TRX_TYPE is TAX, or if the line is for freight. | ||||
GL_DATE | DATE | Accounting date. Date format: RR/MM/DD. Must be in an open or future enterable accounting period. Do not use if the Post To option for the associated transaction type is set to No, or if LINE_TYPE is TAX or FREIGHT. | ||||
DOCUMENT_NUMBER | NUMBER | 18 | Transaction document number. Used if automatic transaction numbering option on the transaction batch source is disabled. Do not use if the LINE_TYPE is TAX or if the line is for freight. | |||
TRX_NUMBER | VARCHAR2 | 20 | Transaction number. Must be unique by transaction source. Do not use if TRX_TYPE is TAX or if the line is for freight. | |||
LINE_NUMBER | NUMBER | 18 | Oracle internal use only. Line number. | |||
QUANTITY | NUMBER | Number of units shipped, or number of the units on a credit memo. Use: period (.) or comma (,) as decimal separator. For debit memos with LINE_TYPE of CHARGES, use: 1. For credit memos with LINE_TYPE of LINE, and CREDIT_METHOD_FOR_ACCT_RULE of UNIT, valid values: 1, -1. | ||||
QUANTITY_ORDERED | NUMBER | Original number of units ordered for the transaction. Use: period (.) or comma (,) as decimal separator. Do not use if LINE_TYPE is TAX, the line is for freight, or for credit memos. | ||||
UNIT_SELLING_PRICE | NUMBER | Selling price per unit. Use: period (.) or comma (,) as decimal separator. Do not use if the LINE_TYPE is tax, if the line is for freight, or for credit memos. | ||||
UNIT_STANDARD_PRICE | NUMBER | Standard unit price. Use: period (.) or comma (,) as decimal separator. | ||||
PRINTING_OPTION | VARCHAR2 | 20 | Printing option. Use Manage Receivables lookups, lookup type INVOICE_PRINTING_OPTION to identify valid values. | |||
INTERFACE_STATUS | VARCHAR2 | 1 | Oracle internal use only. Interface status. | |||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
RELATED_BATCH_SOURCE_NAME | VARCHAR2 | 50 | Batch source of the transaction document. Use Manage Transaction Sources task to identify valid values. Do not use if LINE_TYPE is TAX or if the line is for freight. Do not use for on-account credits or credit memos. | |||
RELATED_TRX_NUMBER | VARCHAR2 | 20 | Document number to which this transaction is related. Must be an existing transaction number in Oracle Fusion Receivables. | |||
RELATED_CUSTOMER_TRX_ID | NUMBER | 18 | Customer transaction identifier of the transaction-related document. Use Manage Transactions task to identify valid values. | |||
PREVIOUS_CUSTOMER_TRX_ID | NUMBER | 18 | Oracle internal use only. Previous customer transaction identifier. | |||
CREDIT_METHOD_FOR_ACCT_RULE | VARCHAR2 | 30 | Credit method for crediting a transaction that uses an accounting rule. Valid values: PRORATE, UNIT, LIFO. Last In first out (LIFO) backs out revenue starting with the last general ledger period and reverses all prior periods until it has used up the credit memo.Prorate credits an equal percentage to all account assignments for this invoice.Unit reverses the revenue for the number of units you specify from an original line of the invoice. Do not use if LINE_TYPE is TAX or CHARGES, or for header freight charges. | |||
CREDIT_METHOD_FOR_INSTALLMENTS | VARCHAR2 | 30 | Credit method for crediting a transaction that uses split payment terms. Valid values: PRORATE, LIFO, or FIFO or NULL. First in first out (FIFO) credits the first installment first. Last in first out (LIFO) credits the last installment first. Prorate credits the installments of the credited transaction and prorates them based on the amount remaining for each installment. Do not use if LINE_TYPE is TAX or CHARGES, or when passing header freight charges. | |||
REASON_CODE | VARCHAR2 | 30 | Transaction line reason code. Use the Manage Receivables lookup task, lookup type INVOICING_REASON or CREDIT_MEMO_REASON to identify valid values. Do not use if LINE_TYPE is TAX, or for freight charges. | |||
TAX_RATE | NUMBER | Tax rate. If LINE_TYPE is TAX you must enter a value for either this or the AMOUNT column. Do not use if LINE_TYPE is LINE, CHARGES, or FREIGHT. | ||||
TAX_CODE | VARCHAR2 | 50 | Tax code. Mandatory if LINE_TYPE is TAX. Do not use if LINE_TYPE is CHARGES or FREIGHT. | |||
TAX_PRECEDENCE | NUMBER | Tax line precedence number. Do not use if LINE_TYPE is LINE, CHARGES, or FREIGHT, or if the line is for freight. | ||||
EXCEPTION_ID | NUMBER | 18 | Oracle internal use only. Tax exception identifier. | |||
EXEMPTION_ID | NUMBER | 18 | Oracle internal use only. Tax exemption identifier. | |||
SHIP_DATE_ACTUAL | DATE | Shipment date. Date format: RR/MM/DD. Do not use if LINE_TYPE is TAX or for freight. | ||||
FOB_POINT | VARCHAR2 | 30 | Freight on Board Point. Do not use if LINE_TYPE is TAX or for freight. Not validated. | |||
SHIP_VIA | VARCHAR2 | 25 | Ship via code. Do not use if LINE_TYPE is TAX, for freight, or for credit memos. Not validated. | |||
WAYBILL_NUMBER | VARCHAR2 | 50 | Waybill number. Free text field. Not validated. | |||
INVOICING_RULE_NAME | VARCHAR2 | 30 | Invoicing rule name. Valid values: In Advance, In Arrears. Mandatory for lines with invoicing rules. Use either INVOICING_RULE_ID or INVOICING_RULE_NAME, but not both. | |||
INVOICING_RULE_ID | NUMBER | 18 | Oracle internal use only. Invoicing rule identifier. | |||
ACCOUNTING_RULE_NAME | VARCHAR2 | 30 | Revenue scheduling rule name. Use the Manage Revenue Scheduling Rules task to identify valid values. | |||
ACCOUNTING_RULE_ID | NUMBER | 18 | Accounting rule identifier. Use Manage Revenue Scheduling Rules task to identify valid values. Do not use if LINE_TYPE is TAX or CHARGES, or if the line is for freight. | |||
ACCOUNTING_RULE_DURATION | NUMBER | 18 | Revenue scheduling rule duration. Do not use for credit memos, on-account credits or if the LINE_TYPE is TAX or CHARGES. Positive integers only. | |||
RULE_START_DATE | DATE | Revenue sharing rule start date. Date format: RR/MM/DD. Must be earlier or equal to RULE_END_DATE. Do not use for credit memos. | ||||
PRIMARY_SALESREP_NUMBER | VARCHAR2 | 30 | Primary salesperson number. Mandatory if the Require Salesrep option is yes. Use Manage Resources task, role Salesperson to identify valid values. Use either PRIMARY_SALESREP_NUMBER or PRIMARY_SALESREP_ID, but not both. Do not use if LINE_TYPE is TAX or CHARGES, or if the line is for freight. | |||
PRIMARY_SALESREP_ID | NUMBER | 18 | Oracle internal use only. Primary salesrep identifier. | |||
SALES_ORDER | VARCHAR2 | 50 | Sales order number. Do not use if LINE_TYPE is TAX, or if the line is for freight. Free text field. Not validated. | |||
SALES_ORDER_LINE | VARCHAR2 | 30 | Sales order line number. Do not use if LINE_TYPE is TAX, or if the line is for freight. Free text field. Not validated. | |||
SALES_ORDER_DATE | DATE | Sales order date. Date format: RR/MM/DD. | ||||
SALES_ORDER_SOURCE | VARCHAR2 | 50 | Sales order source. Free text field. Not validated. | |||
SALES_ORDER_REVISION | NUMBER | Sales order revision number. Free text field. Not validated. | ||||
PURCHASE_ORDER | VARCHAR2 | 50 | Transaction purchase order number. Do not use if LINE_TYPE is TAX, or if the line is for freight. Do not use for credit memos. | |||
PURCHASE_ORDER_REVISION | VARCHAR2 | 50 | Purchase order revision number. Use only if PURCHASE_ORDER is populated. Do not use if LINE_TYPE is TAX, or if the line is for freight. Do not use for credit memos. | |||
PURCHASE_ORDER_DATE | DATE | Purchase order date. Date format: RR/MM/DD. Use only if PURCHASE_ORDER is populated. Do not use if LINE_TYPE is TAX, or if the line is for freight. Do not use for credit memos. | ||||
AGREEMENT_NAME | VARCHAR2 | 30 | Oracle internal use only. Customer agreement name. | |||
AGREEMENT_ID | NUMBER | 18 | Oracle internal use only. Agreement identifier. | |||
MEMO_LINE_NAME | VARCHAR2 | 50 | Standard memo line name. Do not use for credit memos. Use Manage Receivables Memo Lines task to identify valid values. | |||
MEMO_LINE_ID | NUMBER | 18 | Oracle internal use only. Memo line identifier. | |||
INVENTORY_ITEM_ID | NUMBER | 18 | Inventory item identifier. Use Manage Inventory Organization tasks to identify valid values. Use either INVENTORY_ITEM_ID or MEMO_LINE_ID, but not both. | |||
EGP_SYSTEM_ITEMS_SEG1 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG2 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG3 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG4 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG5 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG6 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG7 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG8 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG9 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG10 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG11 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG12 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG13 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG14 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG15 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG16 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG17 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG18 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG19 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
EGP_SYSTEM_ITEMS_SEG20 | VARCHAR2 | 40 | Segment value for the Inventory System Item key flexfield. Use Manage Items page to identify valid values. | |||
REFERENCE_LINE_ID | NUMBER | 18 | Oracle internal use only. Reference line identifier. | |||
REFERENCE_LINE_CONTEXT | VARCHAR2 | 30 | Context code for the Reference Transactions descriptive flexfield. Use Manage Receivables Descriptive Flexfields task to identify valid values. Use REFERENCE_LINE_ATTRIBUTE1 to REFERENCE_LINE_ATTRIBUTE2 for the segment values. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE1 | VARCHAR2 | 30 | Segment value for Reference Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE2 | VARCHAR2 | 30 | Segment value for Reference Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE3 | VARCHAR2 | 30 | Segment value for Reference Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE4 | VARCHAR2 | 30 | Segment value for Reference Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE5 | VARCHAR2 | 30 | Segment value for Reference Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE6 | VARCHAR2 | 30 | Segment value for Reference Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE7 | VARCHAR2 | 30 | Segment value for Reference Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
TERRITORY_ID | NUMBER | 18 | Oracle internal use only. | |||
TERRITORY_SEGMENT1 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT2 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT3 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT4 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT5 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT6 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT7 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT8 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT9 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT10 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT11 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT12 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT13 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT14 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT15 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT16 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT17 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT18 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT19 | VARCHAR2 | 25 | Oracle internal use only. | |||
TERRITORY_SEGMENT20 | VARCHAR2 | 25 | Oracle internal use only. | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Context code for Line Information descriptive flexfield. Use Manage Receivables Descriptive Flexfields task to identify valid values. Use ATTRIBUTE1 to ATTRIBUTE15 for the segment values. | |||
ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Line Information descriptive flexfield. | |||
HEADER_ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Context code for Transaction Information descriptive flexfield. Use the Manage Receivables Descriptive Flexfields task to identify valid values. Use HEADER_ATTRIBUTE1 to HEADER_ATTRIBUTE15 for the segment values. | |||
HEADER_ATTRIBUTE1 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE2 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE3 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE4 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE5 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE6 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE7 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE8 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE9 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE10 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE11 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE12 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE13 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE14 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
HEADER_ATTRIBUTE15 | VARCHAR2 | 150 | Segment value for Transaction Information descriptive flexfield. | |||
COMMENTS | VARCHAR2 | 240 | Oracle internal use only. | |||
INTERNAL_NOTES | VARCHAR2 | 240 | Additional comments. Free text field. Not validated. | |||
INITIAL_CUSTOMER_TRX_ID | NUMBER | 18 | Oracle internal use only. Initial customer transaction identifier. | |||
USSGL_TRANSACTION_CODE_CONTEXT | VARCHAR2 | 30 | Oracle internal use only. | Government Interface Lines (RA_INTERFACE_LINES_GOV) | ||
USSGL_TRANSACTION_CODE | VARCHAR2 | 30 | Oracle internal use only. Transaction code. | Government Interface Lines (RA_INTERFACE_LINES_GOV) | ||
ACCTD_AMOUNT | NUMBER | Oracle internal use only. | ||||
CUSTOMER_BANK_ACCOUNT_ID | NUMBER | 18 | Oracle internal use only. Customer bank account identifier. | |||
CUSTOMER_BANK_ACCOUNT_NAME | VARCHAR2 | 80 | Customer bank account name. From the Billing workarea, use the Manage Customers pane, Payment Details tab to identify valid values. | |||
UOM_CODE | VARCHAR2 | 3 | Unit of measure code for the quantity ordered. Use Manage Units of Measure task to identify valid values. Use either UOM_CODE or UOM_NAME, but not both. | |||
UOM_NAME | VARCHAR2 | 25 | Unit of measure name for the quantity ordered. Use Manage Units of Measure task to identify valid values. Do not use if LINE_TYPE is TAX or CHARGES, if the line is for freight, or for credit memos. Use either UOM_CODE or UOM_NAME, but not both. | |||
DOCUMENT_NUMBER_SEQUENCE_ID | NUMBER | 18 | Oracle internal use only. Document sequence identifier for the transaction. | |||
LINK_TO_LINE_ATTRIBUTE10 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
LINK_TO_LINE_ATTRIBUTE11 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
LINK_TO_LINE_ATTRIBUTE12 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
LINK_TO_LINE_ATTRIBUTE13 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
LINK_TO_LINE_ATTRIBUTE14 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
LINK_TO_LINE_ATTRIBUTE15 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
LINK_TO_LINE_ATTRIBUTE8 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
LINK_TO_LINE_ATTRIBUTE9 | VARCHAR2 | 30 | Segment value for Link-to Transactions descriptive flexfield. | Link-to Transactions (RA_INTERFACE_LINK_TO) | ||
REFERENCE_LINE_ATTRIBUTE10 | VARCHAR2 | 30 | Segment value for Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE11 | VARCHAR2 | 30 | Segment value for Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE12 | VARCHAR2 | 30 | Segment value for Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE13 | VARCHAR2 | 30 | Segment value for Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE14 | VARCHAR2 | 30 | Segment value for Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE15 | VARCHAR2 | 30 | Segment value for Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE8 | VARCHAR2 | 30 | Segment value for Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
REFERENCE_LINE_ATTRIBUTE9 | VARCHAR2 | 30 | Segment value for Transactions descriptive flexfield. | Reference Transactions (RA_INTERFACE_REFERENCE) | ||
INTERFACE_LINE_ATTRIBUTE10 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE11 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE12 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE13 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE14 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE15 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
INTERFACE_LINE_ATTRIBUTE9 | VARCHAR2 | 30 | Segment value for Line Transactions descriptive flexfield. | Line Transactions (RA_INTERFACE_LINES) | ||
VAT_TAX_ID | NUMBER | 18 | Oracle internal use only. | |||
REASON_CODE_MEANING | VARCHAR2 | 80 | Reason code meaning. Use Manage Receivables Lookups, lookup type INVOICING_REASON and CREDIT_MEMO_REASON to identify valid values. | |||
LAST_PERIOD_TO_CREDIT | NUMBER | Last period number for crediting. Credit memo use only. Must be between 0 and the invoice''s accounting rule duration (inclusive). Positive integers only. | ||||
PAYING_CUSTOMER_ID | NUMBER | 18 | Oracle internal use only. Paying customer identifier. | |||
PAYING_SITE_USE_ID | NUMBER | 18 | Oracle internal use only. Paying customer site use identifier. | |||
TAX_EXEMPT_FLAG | VARCHAR2 | 1 | Determines whether a line is tax exempt. Valid values: S, R, E. S means calculate tax per normal Receivables procedures. R means force tax on an invoice line, ignoring exemption certificates. E means exempt. | |||
TAX_EXEMPT_REASON_CODE | VARCHAR2 | 30 | Transaction tax exempt reason code. Use Manage Receivables lookups, lookup type TAX_REASON to identify valid values. | |||
TAX_EXEMPT_REASON_CODE_MEANING | VARCHAR2 | 80 | Transaction tax exempt reason code meaning. Use Manage Receivables lookups, lookup type TAX_REASON to identify valid values. | |||
TAX_EXEMPT_NUMBER | VARCHAR2 | 80 | Tax exemption certificate number. Use if LINE_TYPE is LINE and TAX_EXEMPT_FLAG is E. Otherwise, leave blank. | |||
SALES_TAX_ID | NUMBER | 18 | Oracle internal use only. Sales tax identifier. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
LOCATION_SEGMENT_ID | NUMBER | 18 | Oracle internal use only. Location segment identifier. | |||
MOVEMENT_ID | NUMBER | 18 | Oracle internal use only. Movement identifier for shipping statistics. | |||
ORG_ID | NUMBER | 18 | Business unit identifier. Use the Manage Business units task to identify valid values. | |||
AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2 | 1 | Amount includes tax indicator. Valid values: Y, N. Y means tax is inclusive. N means tax is exclusive. Defaults from tax code if left blank. | |||
HEADER_GDF_ATTR_CATEGORY | VARCHAR2 | 30 | Context code for Receivables Transaction Region Information global descriptive flexfield. Use the Manage Descriptive Flexfields task to identify valid values. Use HEADER_GDF_ATTRIBUTE1 to HEADER_GDF_ATTRIBUTE15 for the segment values. | |||
HEADER_GDF_ATTRIBUTE1 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE2 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE3 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE4 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE5 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE6 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE7 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE8 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE9 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE10 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE11 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE12 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE13 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE14 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE15 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE16 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE17 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE18 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE19 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE20 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE21 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE22 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE23 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE24 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE25 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE26 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE27 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE28 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE29 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
HEADER_GDF_ATTRIBUTE30 | VARCHAR2 | 240 | Segment value for Receivables Transaction Region Information global descriptive flexfield. | |||
LINE_GDF_ATTR_CATEGORY | VARCHAR2 | 30 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE11 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE12 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE13 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE14 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE15 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE16 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE17 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE18 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE19 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
LINE_GDF_ATTRIBUTE20 | VARCHAR2 | 150 | Oracle internal use only. Reserved for country-specific functionality. | |||
RESET_TRX_DATE_FLAG | VARCHAR2 | 1 | Set transaction date to accounting date indicator. Valid values: Y, N. | |||
PAYMENT_SERVER_ORDER_NUM | VARCHAR2 | 80 | Payment server order number. Free text field. Not validated. | |||
APPROVAL_CODE | VARCHAR2 | 80 | Payment approval code from credit card issuer to indicate funds are available. Free text field. Not validated. | |||
ADDRESS_VERIFICATION_CODE | VARCHAR2 | 80 | Credit card address verification code. Free text field. Not validated. | |||
WAREHOUSE_ID | NUMBER | 18 | Oracle internal use only. Identifies the ship-from location to control taxation. | |||
TRANSLATED_DESCRIPTION | VARCHAR2 | 1000 | Transaction line translated description. Free text field. Not validated. Used for Multilingual Support. | |||
CONS_BILLING_NUMBER | VARCHAR2 | 30 | Consolidated billing number. Not used for balance forward bills. Free text field. Must be unique. | |||
PROMISED_COMMITMENT_AMOUNT | NUMBER | Amount reserved for this line from the specified commitment. Free text field. Not validated. | ||||
PAYMENT_SET_ID | NUMBER | 18 | Prepayment receipt identifier. Use only for prepayments. Must be unique. | |||
ORIGINAL_GL_DATE | DATE | Oracle internal use only. Original accounting date. | ||||
CONTRACT_LINE_ID | NUMBER | Oracle internal use only. Contract line identifier. | ||||
CONTRACT_ID | NUMBER | Oracle internal use only. Contract identifier. | ||||
SOURCE_DATA_KEY1 | VARCHAR2 | 150 | Source data attribute for grouping transaction lines into groups. Free text field. Not validated. | |||
SOURCE_DATA_KEY2 | VARCHAR2 | 150 | Source data attribute for grouping transaction lines into groups. Free text field. Not validated. | |||
SOURCE_DATA_KEY3 | VARCHAR2 | 150 | Source data attribute for grouping transaction lines into groups. Free text field. Not validated. | |||
SOURCE_DATA_KEY4 | VARCHAR2 | 150 | Source data attribute for grouping transaction lines into groups. Free text field. Not validated. | |||
SOURCE_DATA_KEY5 | VARCHAR2 | 150 | Source data attribute for grouping transaction lines into groups. Free text field. Not validated. | |||
INVOICED_LINE_ACCTG_LEVEL | VARCHAR2 | 15 | Oracle internal use only. | |||
OVERRIDE_AUTO_ACCOUNTING_FLAG | VARCHAR2 | 1 | Override autoaccounting indicator. Valid values: Y, N. Use for invoices and credit memos. | |||
SOURCE_APPLICATION_ID | NUMBER | 18 | Oracle internal use only. Source application identifier. | |||
SOURCE_EVENT_CLASS_CODE | VARCHAR2 | 30 | Oracle internal use only. Source event class code. | |||
SOURCE_ENTITY_CODE | VARCHAR2 | 30 | Oracle internal use only. Source entity code. | |||
SOURCE_TRX_ID | NUMBER | 18 | Oracle internal use only. Source transaction identifier. | |||
SOURCE_TRX_LINE_ID | NUMBER | 18 | Oracle internal use only. Source transaction line identifier. | |||
SOURCE_TRX_LINE_TYPE | VARCHAR2 | 30 | Oracle internal use only. Source transaction line type. | |||
SOURCE_TRX_DETAIL_TAX_LINE_ID | NUMBER | 18 | Oracle internal use only. Source transaction detail tax line identifier. | |||
HISTORICAL_FLAG | VARCHAR2 | 1 | Oracle internal use only. | |||
TAX_REGIME_CODE | VARCHAR2 | 30 | Entity for defining a common set of tax rules. Use Manage Tax Regimes task to find identify valid values. | |||
TAX | VARCHAR2 | 30 | Tax entity. Use Manage Taxes task to identify valid values. created on the Create Tax UI | |||
TAX_STATUS_CODE | VARCHAR2 | 30 | Tax status code for the taxable nature of a product in the context of a transaction for a tax. Use Manage Tax Statuses task to identify valid values. | |||
TAX_RATE_CODE | VARCHAR2 | 30 | Tax rate code. Defined within the scope of a tax status, tax, and tax regime. Use Manage Tax Regimes task to identify valid values. | |||
TAX_JURISDICTION_CODE | VARCHAR2 | 30 | Tax jurisdiction code. Use Manage Tax Jurisdictions task to identify valid values. | |||
TAXABLE_AMOUNT | NUMBER | The taxable amount for lines of type TAX that are tax inclusive. | ||||
TAXABLE_FLAG | VARCHAR2 | 1 | Indicates whether line is taxable. Valid values: Y, N. | |||
LEGAL_ENTITY_ID | NUMBER | 18 | Oracle internal use only. Legal entity responsible for issuing the transaction line. Derived from business unit. | |||
PARENT_LINE_ID | NUMBER | 18 | Oracle internal use only. Parent line identifier. | |||
DEFERRAL_EXCLUSION_FLAG | VARCHAR2 | 1 | Excludes line from automated revenue deferral. Valid values: Y, N. | |||
PAYMENT_TRXN_EXTENSION_ID | NUMBER | 18 | Oracle internal use only. Oracle Fusion Payments transaction identifier for processing a credit card or bank account payment. | |||
RULE_END_DATE | DATE | Revenue sharing rule end date. Date format: RR/MM/DD. Must be later or equal to RULE_START_DATE. Do not use for credit memos. | ||||
PAYMENT_ATTRIBUTES | VARCHAR2 | 1000 | Oracle internal use only. Payment attributes used for grouping transaction lines. | |||
APPLICATION_ID | NUMBER | 18 | Oracle internal use only. Source application importing transactions into Receivables. | |||
BILLING_DATE | DATE | Billing date to use for invoice creation. | ||||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
RESOURCE_SALESREP_ID | NUMBER | 18 | Sales person identifier. MS: How does the user find valid values? | |||
CUST_TRX_TYPE_SEQ_ID | NUMBER | 18 | Oracle internal use only. Transaction type sequence identifier. | |||
MEMO_LINE_SEQ_ID | NUMBER | 18 | Memo line sequence identifier. | |||
SOURCE_DOCUMENT_NUMBER | VARCHAR2 | 240 | Oracle internal use only. Source document number from upstream applications. | |||
SOURCE_DOCUMENT_ID | NUMBER | 18 | Oracle internal use only. Source document identifier. | |||
SOURCE_DOCUMENT_DATE | DATE | Oracle internal use only. Source document date. | ||||
SOURCE_DOCUMENT_TYPE | VARCHAR2 | 240 | Oracle internal use only. Source document type. | |||
SOURCE_DOCUMENT_LINE_NUMBER | VARCHAR2 | 240 | Oracle internal use only. Line number of source document. | |||
SOURCE_DOCUMENT_LINE_ID | NUMBER | 18 | Oracle internal use only. Source Document Line Identifier. | |||
FAIR_MARKET_VALUE_AMOUNT | NUMBER | Oracle internal use only. Fair market value amount. | ||||
LINK_TO_PARENTLINE_CONTEXT | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE1 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE2 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE3 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE4 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE5 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE6 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE7 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE8 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE9 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE10 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE11 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE12 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE13 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE14 | VARCHAR2 | 240 | Oracle internal use only. | |||
LINK_TO_PARENTLINE_ATTRIBUTE15 | VARCHAR2 | 240 | Oracle internal use only. | |||
TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Transaction business category code. Use the Manage Transaction Business Category Codes task to identify valid values. | |||
PRODUCT_FISC_CLASSIFICATION | VARCHAR2 | 240 | Product classification used by tax authority. Use Manage Product Fiscal Classification Type Group task to identify valid values. | |||
PRODUCT_CATEGORY | VARCHAR2 | 240 | Product fiscal classification for tax purposes such as tax determination and reporting. For non inventory items. Use Manage Product Category Fiscal Classification Codes task to identify valid values. | |||
PRODUCT_TYPE | VARCHAR2 | 240 | Product type. Valid values: GOODS, SERVICES. | |||
LINE_INTENDED_USE | VARCHAR2 | 240 | Tax classification based upon the product purpose. Use Manage Intended Use Fiscal Classification task to identify valid values. | |||
ASSESSABLE_VALUE | NUMBER | Assessed value for tax calculation purposes. Use: period (.) or comma (,) as decimal separator. | ||||
DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Classification used by a tax authority to categorize a document associated with a transaction for a tax. Use Manage Document Fiscal Classification Codes task to identify valid values. | |||
DEFAULT_TAXATION_COUNTRY | VARCHAR2 | 2 | Country where transaction is deemed to have occurred for taxation purposes. | |||
USER_DEFINED_FISC_CLASS | VARCHAR2 | 30 | User defined fiscal classification. Free text field. Not validated. | |||
INTERFACE_LINE_GUID | VARCHAR2 | 32 | Oracle internal use only. Unique global identifier. | |||
INTERCOMPANY_FLAG | VARCHAR2 | 1 | Intercompany invoice indicator. Valid values: Y, NULL. | |||
TAX_INVOICE_NUMBER | VARCHAR2 | 150 | Tax invoice number. Must be unique. | |||
TAX_INVOICE_DATE | DATE | Tax invoice date. Date format: RR/MM/DD. | ||||
FINAL_DISCHARGE_LOCATION_ID | NUMBER | 18 | End final discharge point or final customer location where shipment will be sent | |||
FIRST_PTY_REG_ID | NUMBER | 18 | Deploying company's Tax Registration number | |||
THIRD_PTY_REG_ID | NUMBER | 18 | Bill-to Customer Tax Registration Number | |||
HEADER_GDF_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_NUMBER6 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_NUMBER7 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_NUMBER8 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_NUMBER9 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_NUMBER10 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_NUMBER11 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_NUMBER12 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
HEADER_GDF_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
LINE_GDF_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
LINE_GDF_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
LINE_GDF_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
LINE_GDF_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
LINE_GDF_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
LINE_GDF_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
LINE_GDF_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
LINE_GDF_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
LINE_GDF_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
LINE_GDF_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||||
AUTHORIZATION_NUMBER | VARCHAR2 | 30 | Credit check authorization number linked to the invoice. | |||
AUTH_COMPLETE_FLAG | VARCHAR2 | 1 | Indicates whether credit check authorization is complete. | |||
LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | |||
WAREHOUSE_CODE | VARCHAR2 | 18 | Inventory organization code indicating ship from location. Use the Manage Inventory Organizations task to find a valid warehouse code. | |||
LAST_TRX_DEBIT_AUTH_FLAG | VARCHAR2 | 1 | Specifies whether a transaction is the last one of a recurrent series of ISO20022 direct debit collections for a given debit authorization. Valid values are Y and N. | |||
FIRST_PTY_REG_NUM | VARCHAR2 | 60 | First party tax registration number of the transaction. | |||
THIRD_PTY_REG_NUM | VARCHAR2 | 60 | Third party tax registration number of the transaction. | |||
FINAL_DISCHARGE_LOCATION_CODE | VARCHAR2 | 60 | Final destination location code for the purchases made by the customer. | |||
INTENDED_USE_CLASSIF_ID | NUMBER | 18 | Intended use identifier of the transaction line. It identifies the purpose for which the product is used. | |||
PROD_FC_CATEG_ID | NUMBER | 18 | Product fiscal classification identifier of the inventory item. | |||
ORIG_SYS_SOLD_PARTY_ID | NUMBER | 18 | Original system sold-to customer identifier. Use either ORIG_SYS_SOLD_PARTY_REF or ORIG_SYS_SOLD_PARTY_ID , but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYS_SOLD_PARTY_REF | VARCHAR2 | 255 | Original system sold-to customer reference. Use either ORIG_SYS_SOLD_PARTY_REF or ORIG_SYS_SOLD_PARTY_ID , but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYS_SHIP_PTY_CONTACT_ID | NUMBER | 18 | Original system shipping contact identifier. Use either ORIG_SYS_SHIP_PTY_CONTACT_REF or ORIG_SYS_SHIP_PTY_CONTACT_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYS_SHIP_PTY_CONTACT_REF | VARCHAR2 | 255 | Original system shipping contact reference. Use either ORIG_SYS_SHIP_PTY_CONTACT_REF or ORIG_SYS_SHIP_PTY_CONTACT_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYS_SHIP_PARTY_SITE_ID | NUMBER | 18 | Original system shipping address identifier. Use either ORIG_SYS_SHIP_PARTY_SITE_REF or ORIG_SYS_SHIP_PARTY_SITE_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYS_SHIP_PARTY_SITE_REF | VARCHAR2 | 255 | Original system shipping address reference. Use either ORIG_SYS_SHIP_PARTY_SITE_REF or ORIG_SYS_SHIP_PARTY_SITE_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYS_SHIP_PARTY_ID | NUMBER | 18 | Original system ship-to party identifier. Use either ORIG_SYS_SHIP_PARTY_ID or ORIG_SYS_SHIP_PARTY_REF, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
ORIG_SYS_SHIP_PARTY_REF | VARCHAR2 | 255 | Original system ship-to party reference. Use either ORIG_SYS_SHIP_PARTY_REF or ORIG_SYS_SHIP_PARTY_ID, but not both. Do not use if LINE_TYPE is TAX or if freight the line is for freight. | |||
BILL_CUSTOMER_ACCOUNT_NUMBER | VARCHAR2 | 30 | Bill-to customer account number of the transaction. | |||
BILL_CUSTOMER_SITE_NUMBER | VARCHAR2 | 30 | Bill-to customer address site number. Site number represents a location in the system. | |||
SHIP_PARTY_NUMBER | VARCHAR2 | 30 | Ship-to party number of the transaction. | |||
SHIP_PARTY_SITE_NUMBER | VARCHAR2 | 30 | Ship-to party address site number. Site number represents a location in the system. | |||
SOLD_PARTY_NUMBER | VARCHAR2 | 30 | Sold-to party number of the transaction. | |||
BILL_CONTACT_PARTY_NUMBER | VARCHAR2 | 30 | Contact person party number of the bill-to customer. | |||
SHIP_CONTACT_PARTY_NUMBER | VARCHAR2 | 30 | Contact person party number of the ship-to customer. | |||
SHIP_CUSTOMER_ACCOUNT_NUMBER | VARCHAR2 | 30 | Ship-to customer account number of the transaction. | |||
SHIP_CUSTOMER_SITE_NUMBER | VARCHAR2 | 30 | Ship-to customer account address site number. Site number represents a location in the system. | |||
SOLD_CUSTOMER_ACCOUNT_NUMBER | VARCHAR2 | 20 | Sold-to customer account number of the transaction. | |||
DOCUMENT_TYPE_ID | NUMBER | 18 | Unique identifier of a source document type. | |||
DOC_LINE_ID_INT_1 | NUMBER | Source document line unique identifier. | ||||
DOC_LINE_ID_INT_2 | NUMBER | Source document line unique identifier. | ||||
DOC_LINE_ID_INT_3 | NUMBER | Source document line unique identifier. | ||||
DOC_LINE_ID_INT_4 | NUMBER | Source document line unique identifier. | ||||
DOC_LINE_ID_INT_5 | NUMBER | Source document line unique identifier. | ||||
DOC_LINE_ID_CHAR_1 | VARCHAR2 | 30 | Unique identifier of the source document line. | |||
DOC_LINE_ID_CHAR_2 | VARCHAR2 | 30 | Unique identifier of the source document line. | |||
DOC_LINE_ID_CHAR_3 | VARCHAR2 | 30 | Unique identifier of the source document line. | |||
DOC_LINE_ID_CHAR_4 | VARCHAR2 | 30 | Unique identifier of the source document line. | |||
DOC_LINE_ID_CHAR_5 | VARCHAR2 | 30 | Unique identifier of the source document line. | |||
SOURCE_SYSTEM | VARCHAR2 | 120 | The source system sending the data. | |||
DOCUMENT_CREATION_DATE | DATE | Date when the document is created in the source application. | ||||
REV_REC_APPLICATION | VARCHAR2 | 30 | Indicates the application is used for revenue recognition. | |||
RECURRING_BILL_FLAG | VARCHAR2 | 1 | Option that indicates whether the line is for a recurring invoice. Valid values are Y, N, null. Null is the same as N. | |||
CONTRACT_START_DATE | DATE | The start date of the contract, if the transaction line is associated with a contract. | ||||
CONTRACT_END_DATE | DATE | The end date of the contract, if the transaction line is associated with a contract. | ||||
RECURRING_BILL_PLAN_ID | NUMBER | 18 | Unique identifier for the recurring bill plan associated with the invoice. | |||
BILLING_PERIOD_START_DATE | DATE | The start date of the billing period associated with the invoice. | ||||
BILLING_PERIOD_END_DATE | DATE | The end date of the billing period associated with the invoice. | ||||
ITEM_NUMBER | VARCHAR2 | 300 | Item number for the inventory item associated with the transaction line. | |||
RECURRING_BILL_PLAN_LINE_ID | NUMBER | 18 | Unique identifier for the recurring bill plan line associated with the credit memo. | |||
BU_NAME | VARCHAR2 | 240 | Indicates the name of the business unit associated with the row. | |||
LEGAL_ENTITY_IDENTIFIER | VARCHAR2 | 30 | Unique number used to identify a legal entity for this row. | |||
BILL_PLAN_ID | NUMBER | 18 | Identifier of the recurring bill plan. | |||
BILL_PLAN_LINE_ID | NUMBER | 18 | Identifier of the recurring bill plan line. | |||
FREIGHT_CHARGE | NUMBER | Freight amount charged to the customer for the sale of item on the line. | ||||
INSURANCE_CHARGE | NUMBER | Insurance amount charged to the customer for the sale of item on the line. | ||||
PACKING_CHARGE | NUMBER | Packing amount charged to the customer for the sale of item on the line. | ||||
MISCELLANEOUS_CHARGE | NUMBER | Other charge amount charged to the customer for the sale of item on the line. | ||||
COMMERCIAL_DISCOUNT | NUMBER | Commercial discount extended to the customer for the purchase of the item on the line. | ||||
CC_TOKEN_NUMBER | VARCHAR2 | 30 | Token number issued by CyberSource corresponding to a credit card number. | |||
CC_EXPIRATION_DATE | DATE | Expiration date of the credit card. It must be numeric in YYYY/MM/DD format. | ||||
CC_FIRST_NAME | VARCHAR2 | 40 | First name of the credit card holder. | |||
CC_LAST_NAME | VARCHAR2 | 40 | Last name of the credit card holder. | |||
CC_ISSUER_CODE | VARCHAR2 | 30 | Card issuer code of brand like Visa, MasterCard etc. Code values are from lookup IBY_CARD_TYPES. | |||
HEADER_ATTRIBUTE_DATE1 | DATE | Segment value for transaction information descriptive flexfield. | ||||
HEADER_ATTRIBUTE_DATE2 | DATE | Segment value for transaction information descriptive flexfield. | ||||
HEADER_ATTRIBUTE_DATE3 | DATE | Segment value for transaction information descriptive flexfield. | ||||
HEADER_ATTRIBUTE_DATE4 | DATE | Segment value for transaction information descriptive flexfield. | ||||
HEADER_ATTRIBUTE_DATE5 | DATE | Segment value for transaction information descriptive flexfield. | ||||
HEADER_ATTRIBUTE_NUMBER1 | NUMBER | Segment value for transaction information descriptive flexfield. | ||||
HEADER_ATTRIBUTE_NUMBER2 | NUMBER | Segment value for transaction information descriptive flexfield. | ||||
HEADER_ATTRIBUTE_NUMBER3 | NUMBER | Segment value for transaction information descriptive flexfield. | ||||
HEADER_ATTRIBUTE_NUMBER4 | NUMBER | Segment value for transaction information descriptive flexfield. | ||||
HEADER_ATTRIBUTE_NUMBER5 | NUMBER | Segment value for transaction information descriptive flexfield. | ||||
CC_MASKED_NUMBER | VARCHAR2 | 30 | Masked credit card number; to be used for display purposes. | |||
CC_AUTH_REQUEST_ID | VARCHAR2 | 30 | Authorization request identifier. | |||
CC_AUTH_CODE | VARCHAR2 | 256 | Authorization code received from the credit card processing system for authorization. | |||
CC_VOICE_AUTH_CODE | VARCHAR2 | 100 | Voice authorization code received from the credit card processing system for authorization. | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
PREPAY_CUSTOMER_TRX_ID | NUMBER | 18 | Oracle internal use only. Prepayment customer transaction identifier. | |||
PREPAY_CUSTOMER_TRX_LINE_ID | NUMBER | 18 | Oracle internal use only. Prepayment customer transaction line identifier. | |||
ADDITIONAL_LINE_CONTEXT | VARCHAR2 | 30 | Context name for the Additional Reference Transactions descriptive flexfield. Use the Manage Receivables Descriptive Flexfields task to identify valid values. Use ADDITIONAL_LINE_ATTRIBUTE1 to ADDITIONAL_LINE_ATTRIBUTE15 for the segment values. | |||
ADDITIONAL_LINE_ATTRIBUTE1 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield1. | |||
ADDITIONAL_LINE_ATTRIBUTE2 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield2. | |||
ADDITIONAL_LINE_ATTRIBUTE3 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield3. | |||
ADDITIONAL_LINE_ATTRIBUTE4 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield4. | |||
ADDITIONAL_LINE_ATTRIBUTE5 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield5. | |||
ADDITIONAL_LINE_ATTRIBUTE6 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield6. | |||
ADDITIONAL_LINE_ATTRIBUTE7 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield7. | |||
ADDITIONAL_LINE_ATTRIBUTE8 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield8. | |||
ADDITIONAL_LINE_ATTRIBUTE9 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield9. | |||
ADDITIONAL_LINE_ATTRIBUTE10 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield10. | |||
ADDITIONAL_LINE_ATTRIBUTE11 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield11. | |||
ADDITIONAL_LINE_ATTRIBUTE12 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield12. | |||
ADDITIONAL_LINE_ATTRIBUTE13 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield13. | |||
ADDITIONAL_LINE_ATTRIBUTE14 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield14. | |||
ADDITIONAL_LINE_ATTRIBUTE15 | VARCHAR2 | 30 | Segment value for Additional Reference Transactions descriptive flexfield15. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
RA_INTERFACE_LINES_ALL | hz_cust_accounts | ORIG_SYSTEM_SOLD_CUSTOMER_ID |
RA_INTERFACE_LINES_ALL | hz_cust_accounts | PAYING_CUSTOMER_ID |
RA_INTERFACE_LINES_ALL | hz_cust_site_uses_all | PAYING_SITE_USE_ID |
RA_INTERFACE_LINES_ALL | iby_fndcpt_tx_extensions | PAYMENT_TRXN_EXTENSION_ID |
RA_INTERFACE_LINES_ALL | ra_cust_trx_types_all | CUST_TRX_TYPE_SEQ_ID |
RA_INTERFACE_LINES_ALL | ra_terms_b | TERM_ID |
RA_INTERFACE_LINES_ALL | ar_receipt_methods | RECEIPT_METHOD_ID |
RA_INTERFACE_LINES_ALL | gl_daily_conversion_types | CONVERSION_TYPE |
RA_INTERFACE_LINES_ALL | ra_customer_trx_all | CUSTOMER_TRX_ID |
RA_INTERFACE_LINES_ALL | ra_customer_trx_all | RELATED_CUSTOMER_TRX_ID |
RA_INTERFACE_LINES_ALL | ra_customer_trx_all | PREVIOUS_CUSTOMER_TRX_ID |
RA_INTERFACE_LINES_ALL | ra_rules | INVOICING_RULE_ID |
RA_INTERFACE_LINES_ALL | ra_rules | ACCOUNTING_RULE_ID |
RA_INTERFACE_LINES_ALL | jtf_rs_salesreps | RESOURCE_SALESREP_ID |
RA_INTERFACE_LINES_ALL | egp_system_items_b | INVENTORY_ITEM_ID, ORG_ID |
RA_INTERFACE_LINES_ALL | ra_customer_trx_lines_all | REFERENCE_LINE_ID |
RA_INTERFACE_LINES_ALL | ra_customer_trx_all | INITIAL_CUSTOMER_TRX_ID |
RA_INTERFACE_LINES_ALL | iby_ext_bank_accounts | CUSTOMER_BANK_ACCOUNT_ID |
RA_INTERFACE_LINES_ALL | hz_cust_acct_sites_all | ORIG_SYSTEM_BILL_ADDRESS_ID |
RA_INTERFACE_LINES_ALL | ra_customer_trx_all | INTERFACE_LINE_ID |
RA_INTERFACE_LINES_ALL | ra_customer_trx_lines_all | SOURCE_TRX_LINE_ID |
RA_INTERFACE_LINES_ALL | zx_lines | SOURCE_TRX_DETAIL_TAX_LINE_ID |
RA_INTERFACE_LINES_ALL | hz_cust_account_roles | ORIG_SYSTEM_BILL_CONTACT_ID |
RA_INTERFACE_LINES_ALL | xle_entity_profiles | LEGAL_ENTITY_ID |
RA_INTERFACE_LINES_ALL | hz_parties | ORIG_SYS_SHIP_PARTY_ID |
RA_INTERFACE_LINES_ALL | hz_parties | ORIG_SYS_SOLD_PARTY_ID |
RA_INTERFACE_LINES_ALL | hz_party_sites | ORIG_SYS_SHIP_PARTY_SITE_ID |
RA_INTERFACE_LINES_ALL | vrm_source_doc_types_b | DOCUMENT_TYPE_ID |
RA_INTERFACE_LINES_ALL | ra_recurring_bill_plans | RECURRING_BILL_PLAN_ID |
RA_INTERFACE_LINES_ALL | ra_recurring_bill_plan_lines | RECURRING_BILL_PLAN_LINE_ID |
RA_INTERFACE_LINES_ALL | hz_cust_accounts | ORIG_SYSTEM_BILL_CUSTOMER_ID |
RA_INTERFACE_LINES_ALL | hz_cust_acct_sites_all | ORIG_SYSTEM_SHIP_ADDRESS_ID |
RA_INTERFACE_LINES_ALL | hz_cust_account_roles | ORIG_SYSTEM_SHIP_CONTACT_ID |
RA_INTERFACE_LINES_ALL | hz_cust_accounts | ORIG_SYSTEM_SHIP_CUSTOMER_ID |
RA_INTERFACE_LINES_ALL | ra_customer_trx_all | PREPAY_CUSTOMER_TRX_ID |
RA_INTERFACE_LINES_ALL | ra_customer_trx_lines_all | PREPAY_CUSTOMER_TRX_LINE_ID |
Indexes
Index | Uniqueness | Tablespace | Columns | Status |
---|---|---|---|---|
RA_INTERFACE_LINES_N1 | Non Unique | Default | REQUEST_ID | |
RA_INTERFACE_LINES_N2 | Non Unique | Default | CUSTOMER_TRX_ID | |
RA_INTERFACE_LINES_N3 | Non Unique | Default | LINK_TO_LINE_ID | |
RA_INTERFACE_LINES_N4 | Non Unique | Default | REFERENCE_LINE_ID | |
RA_INTERFACE_LINES_N5 | Non Unique | Default | TRX_NUMBER, REQUEST_ID | |
RA_INTERFACE_LINES_N6 | Non Unique | Default | DOCUMENT_NUMBER | |
RA_INTERFACE_LINES_N7 | Non Unique | Default | ORG_ID, NVL("INTERFACE_STATUS", 'N') | Obsolete |
RA_INTERFACE_LINES_N8 | Non Unique | Default | LINK_TO_LINE_CONTEXT, LINK_TO_LINE_ATTRIBUTE1, LINK_TO_LINE_ATTRIBUTE2, LINK_TO_LINE_ATTRIBUTE3, LINK_TO_LINE_ATTRIBUTE4, LINK_TO_LINE_ATTRIBUTE5, LINK_TO_LINE_ATTRIBUTE6, LINK_TO_LINE_ATTRIBUTE7, LINK_TO_LINE_ATTRIBUTE8, LINK_TO_LINE_ATTRIBUTE9, LINK_TO_LINE_ATTRIBUTE10, LINK_TO_LINE_ATTRIBUTE11, LINK_TO_LINE_ATTRIBUTE12, LINK_TO_LINE_ATTRIBUTE13, LINK_TO_LINE_ATTRIBUTE14, LINK_TO_LINE_ATTRIBUTE15 | |
RA_INTERFACE_LINES_N9 | Non Unique | Default | LINK_TO_LINE_CONTEXT, NVL("LINK_TO_LINE_ATTRIBUTE1",'~'), NVL("LINK_TO_LINE_ATTRIBUTE2",'~'), NVL("LINK_TO_LINE_ATTRIBUTE3",'~'), NVL("LINK_TO_LINE_ATTRIBUTE4",'~'), NVL("LINK_TO_LINE_ATTRIBUTE5",'~'), NVL("LINK_TO_LINE_ATTRIBUTE6",'~'), NVL("LINK_TO_LINE_ATTRIBUTE7",'~'), NVL("LINK_TO_LINE_ATTRIBUTE8",'~'), NVL("LINK_TO_LINE_ATTRIBUTE9",'~'), NVL("LINK_TO_LINE_ATTRIBUTE10",'~'), NVL("LINK_TO_LINE_ATTRIBUTE11",'~'), NVL("LINK_TO_LINE_ATTRIBUTE12",'~'), NVL("LINK_TO_LINE_ATTRIBUTE13",'~'), NVL("LINK_TO_LINE_ATTRIBUTE14",'~'), NVL("LINK_TO_LINE_ATTRIBUTE15",'~') | |
RA_INTERFACE_LINES_N10 | Non Unique | Default | INTERFACE_LINE_CONTEXT, NVL("INTERFACE_LINE_ATTRIBUTE1",'~'), NVL("INTERFACE_LINE_ATTRIBUTE2",'~'), NVL("INTERFACE_LINE_ATTRIBUTE3",'~'), NVL("INTERFACE_LINE_ATTRIBUTE4",'~'), NVL("INTERFACE_LINE_ATTRIBUTE5",'~'), NVL("INTERFACE_LINE_ATTRIBUTE6",'~'), NVL("INTERFACE_LINE_ATTRIBUTE7",'~'), NVL("INTERFACE_LINE_ATTRIBUTE8",'~'), NVL("INTERFACE_LINE_ATTRIBUTE9",'~'), NVL("INTERFACE_LINE_ATTRIBUTE10",'~'), NVL("INTERFACE_LINE_ATTRIBUTE11",'~'), NVL("INTERFACE_LINE_ATTRIBUTE12",'~'), NVL("INTERFACE_LINE_ATTRIBUTE13",'~'), NVL("INTERFACE_LINE_ATTRIBUTE14",'~'), NVL("INTERFACE_LINE_ATTRIBUTE15",'~') | |
RA_INTERFACE_LINES_U1 | Unique | Default | INTERFACE_LINE_ID | |
RA_INTERFACE_LINES_U2 | Unique | Default | INTERFACE_LINE_GUID |