Accounts Receivable Auto Invoice Data Population in FBDI
Download "AutoInvoice" FBDI Template from Oracle OER
Sheet: RA_INTERFACE_LINES_ALL
|
FBDI Columns |
Description |
Mandatory |
|
Business
Unit Identifier |
|
|
|
*Business
Unit Name |
Needed
Business Unit |
|
|
*Transaction
Batch Source Name |
Needed
based on Transaction Source Defined in Configuration |
|
|
*Transaction
Type Name |
Needed
based on Transaction Type defined in the Configuration |
|
|
Payment
Terms |
Needed
based on Payment Terms Defined in the Configuration |
|
|
Transaction
Date |
Needed |
|
|
Accounting
Date |
Needed |
|
|
Transaction
Number |
|
|
|
Original
System Bill-to Customer Reference |
Needed customer
reference against which the Invoice is raised |
|
|
Original
System Bill-to Customer Address Reference |
Needed
Customer Bill To Address reference |
|
|
Original
System Bill-to Customer Contact Reference |
|
|
|
Original
System Ship-to Customer Reference |
|
|
|
Original
System Ship-to Customer Address Reference |
|
|
|
Original
System Ship-to Customer Contact Reference |
|
|
|
Original
System Ship-to Customer Account Reference |
Needed
customer reference against which the Invoice is raised |
|
|
Original
System Ship-to Customer Account Address Reference |
Needed
Customer Ship To Address reference |
|
|
Original
System Ship-to Customer Account Contact Reference |
|
|
|
Original
System Sold-to Customer Reference |
|
|
|
Original
System Sold-to Customer Account Reference |
|
|
|
Bill-to
Customer Account Number |
|
|
|
Bill-to
Customer Site Number |
|
|
|
Bill-to
Contact Party Number |
|
|
|
Ship-to
Customer Account Number |
|
|
|
Ship-to
Customer Site Number |
|
|
|
Ship-to
Contact Party Number |
|
|
|
Sold-to
Customer Account Number |
|
|
|
*Transaction
Line Type |
Needed |
|
|
*Transaction
Line Description |
Needed |
|
|
*Currency
Code |
Needed |
|
|
*Currency
Conversion Type |
Needed |
|
|
Currency
Conversion Date |
Needed |
|
|
Currency
Conversion Rate |
Needed |
|
|
Transaction
Line Amount |
Needed |
|
|
Transaction
Line Quantity |
Needed |
|
|
Customer
Ordered Quantity |
|
|
|
Unit
Selling Price |
Needed |
|
|
Unit
Standard Price |
|
|
|
Line
Transactions Flexfield Context |
|
|
|
Line
Transactions Flexfield Segment 1 |
|
|
|
Line
Transactions Flexfield Segment 2 |
|
|
|
Line
Transactions Flexfield Segment 3 |
|
|
|
Line
Transactions Flexfield Segment 4 |
|
|
|
Line
Transactions Flexfield Segment 5 |
|
|
|
Line
Transactions Flexfield Segment 6 |
|
|
|
Line
Transactions Flexfield Segment 7 |
|
|
|
Line
Transactions Flexfield Segment 8 |
|
|
|
Line
Transactions Flexfield Segment 9 |
|
|
|
Line
Transactions Flexfield Segment 10 |
|
|
|
Line
Transactions Flexfield Segment 11 |
|
|
|
Line
Transactions Flexfield Segment 12 |
|
|
|
Line
Transactions Flexfield Segment 13 |
|
|
|
Line
Transactions Flexfield Segment 14 |
|
|
|
Line
Transactions Flexfield Segment 15 |
|
|
|
Primary
Salesperson Number |
|
|
|
Tax
Classification Code |
Needed |
|
|
Legal
Entity Identifier |
|
|
|
Accounted
Amount in Ledger Currency |
|
|
|
Sales
Order Number |
Needed |
|
|
Sales
Order Date |
Needed |
|
|
Actual
Ship Date |
Needed |
|
|
Warehouse
Code |
|
|
|
Unit of
Measure Code |
Needed
based on UOM lookup defined in Configuration |
|
|
Unit of
Measure Name |
|
|
|
Invoicing
Rule Name |
|
|
|
Revenue
Scheduling Rule Name |
|
|
|
Number
of Revenue Periods |
|
|
|
Revenue
Scheduling Rule Start Date |
|
|
|
Revenue
Scheduling Rule End Date |
|
|
|
Reason
Code Meaning |
|
|
|
Last
Period to Credit |
|
|
|
Transaction
Business Category Code |
|
|
|
Product
Fiscal Classification Code |
|
|
|
Product
Category Code |
|
|
|
Product
Type |
|
|
|
Line
Intended Use Code |
|
|
|
Assessable
Value |
|
|
|
Document
Sub Type |
|
|
|
Default
Taxation Country |
Needed |
|
|
User
Defined Fiscal Classification |
|
|
|
Tax
Invoice Number |
|
|
|
Tax
Invoice Date |
|
|
|
Tax
Regime Code |
|
|
|
Tax |
|
|
|
Tax
Status Code |
|
|
|
Tax Rate
Code |
|
|
|
Tax
Jurisdiction Code |
|
|
|
First
Party Registration Number |
|
|
|
Third
Party Registration Number |
|
|
|
Final
Discharge Location |
|
|
|
Taxable
Amount |
|
|
|
Taxable
Flag |
|
|
|
Tax
Exemption Flag |
|
|
|
Tax
Exemption Reason Code |
|
|
|
Tax
Exemption Reason Code Meaning |
|
|
|
Tax
Exemption Certificate Number |
|
|
|
Line
Amount Includes Tax Flag |
|
|
|
Tax
Precedence |
|
|
|
Credit
Method To Be Used For Lines With Revenue Scheduling Rules |
|
|
|
Credit
Method To Be Used For Transactions With Split Payment Terms |
|
|
|
Reason
Code |
|
|
|
Tax Rate |
|
|
|
FOB
Point |
|
|
|
Carrier |
|
|
|
Shipping
Reference |
|
|
|
Sales
Order Line Number |
|
|
|
Sales
Order Source |
|
|
|
Sales
Order Revision Number |
|
|
|
Purchase
Order Number |
|
|
|
Purchase
Order Revision Number |
|
|
|
Purchase
Order Date |
|
|
|
Agreement
Name |
|
|
|
Memo
Line Name |
|
|
|
Document
Number |
|
|
|
Original
System Batch Name |
|
|
|
Link-to
Transactions Flexfield Context |
|
|
|
Link-to
Transactions Flexfield Segment 1 |
|
|
|
Link-to
Transactions Flexfield Segment 2 |
|
|
|
Link-to
Transactions Flexfield Segment 3 |
|
|
|
Link-to
Transactions Flexfield Segment 4 |
|
|
|
Link-to
Transactions Flexfield Segment 5 |
|
|
|
Link-to
Transactions Flexfield Segment 6 |
|
|
|
Link-to
Transactions Flexfield Segment 7 |
|
|
|
Link-to
Transactions Flexfield Segment 8 |
|
|
|
Link-to
Transactions Flexfield Segment 9 |
|
|
|
Link-to
Transactions Flexfield Segment 10 |
|
|
|
Link-to
Transactions Flexfield Segment 11 |
|
|
|
Link-to
Transactions Flexfield Segment 12 |
|
|
|
Link-to
Transactions Flexfield Segment 13 |
|
|
|
Link-to
Transactions Flexfield Segment 14 |
|
|
|
Link-to
Transactions Flexfield Segment 15 |
|
|
|
Reference
Transactions Flexfield Context |
|
|
|
Reference
Transactions Flexfield Segment 1 |
|
|
|
Reference
Transactions Flexfield Segment 2 |
|
|
|
Reference
Transactions Flexfield Segment 3 |
|
|
|
Reference
Transactions Flexfield Segment 4 |
|
|
|
Reference
Transactions Flexfield Segment 5 |
|
|
|
Reference
Transactions Flexfield Segment 6 |
|
|
|
Reference
Transactions Flexfield Segment 7 |
|
|
|
Reference
Transactions Flexfield Segment 8 |
|
|
|
Reference
Transactions Flexfield Segment 9 |
|
|
|
Reference
Transactions Flexfield Segment 10 |
|
|
|
Reference
Transactions Flexfield Segment 11 |
|
|
|
Reference
Transactions Flexfield Segment 12 |
|
|
|
Reference
Transactions Flexfield Segment 13 |
|
|
|
Reference
Transactions Flexfield Segment 14 |
|
|
|
Reference
Transactions Flexfield Segment 15 |
|
|
|
Link To
Parent Line Context |
|
|
|
Link To
Parent Line Segment 1 |
|
|
|
Link To
Parent Line Segment 2 |
|
|
|
Link To
Parent Line Segment 3 |
|
|
|
Link To
Parent Line Segment 4 |
|
|
|
Link To
Parent Line Segment 5 |
|
|
|
Link To
Parent Line Segment 6 |
|
|
|
Link To
Parent Line Segment 7 |
|
|
|
Link To
Parent Line Segment 8 |
|
|
|
Link To
Parent Line Segment 9 |
|
|
|
Link To
Parent Line Segment 10 |
|
|
|
Link To
Parent Line Segment 11 |
|
|
|
Link To
Parent Line Segment 12 |
|
|
|
Link To
Parent Line Segment 13 |
|
|
|
Link To
Parent Line Segment 14 |
|
|
|
Link To
Parent Line Segment 15 |
|
|
|
Receipt
Method Name |
|
|
|
Printing
Option |
|
|
|
Related
Batch Source Name |
|
|
|
Related
Transaction Number |
|
|
|
Inventory
Item Number |
|
|
|
Inventory
Item Segment 2 |
|
|
|
Inventory
Item Segment 3 |
|
|
|
Inventory
Item Segment 4 |
|
|
|
Inventory
Item Segment 5 |
|
|
|
Inventory
Item Segment 6 |
|
|
|
Inventory
Item Segment 7 |
|
|
|
Inventory
Item Segment 8 |
|
|
|
Inventory
Item Segment 9 |
|
|
|
Inventory
Item Segment 10 |
|
|
|
Inventory
Item Segment 11 |
|
|
|
Inventory
Item Segment 12 |
|
|
|
Inventory
Item Segment 13 |
|
|
|
Inventory
Item Segment 14 |
|
|
|
Inventory
Item Segment 15 |
|
|
|
Inventory
Item Segment 16 |
|
|
|
Inventory
Item Segment 17 |
|
|
|
Inventory
Item Segment 18 |
|
|
|
Inventory
Item Segment 19 |
|
|
|
Inventory
Item Segment 20 |
|
|
|
Bill To
Customer Bank Account Name |
|
|
|
Reset
Transaction Date Flag |
|
|
|
Payment
Server Order Number |
|
|
|
Last
Transaction on Debit Authorization |
|
|
|
Approval
Code |
|
|
|
Address
Verification Code |
|
|
|
Transaction
Line Translated Description |
|
|
|
Consolidated
Billing Number |
|
|
|
Promised
Commitment Amount |
|
|
|
Payment
Set Identifier |
|
|
|
Original
Accounting Date |
|
|
|
Invoiced
Line Accounting Level |
|
|
|
Override
AutoAccounting Flag |
|
|
|
Historical
Flag |
|
|
|
Deferral
Exclusion Flag |
|
|
|
Payment
Attributes |
|
|
|
Invoice
Billing Date |
|
|
|
Invoice
Lines Flexfield Context |
|
|
|
Invoice
Lines Flexfield Segment 1 |
|
|
|
Invoice
Lines Flexfield Segment 2 |
|
|
|
Invoice
Lines Flexfield Segment 3 |
|
|
|
Invoice
Lines Flexfield Segment 4 |
|
|
|
Invoice
Lines Flexfield Segment 5 |
|
|
|
Invoice
Lines Flexfield Segment 6 |
|
|
|
Invoice
Lines Flexfield Segment 7 |
|
|
|
Invoice
Lines Flexfield Segment 8 |
|
|
|
Invoice
Lines Flexfield Segment 9 |
|
|
|
Invoice
Lines Flexfield Segment 10 |
|
|
|
Invoice
Lines Flexfield Segment 11 |
|
|
|
Invoice
Lines Flexfield Segment 12 |
|
|
|
Invoice
Lines Flexfield Segment 13 |
|
|
|
Invoice
Lines Flexfield Segment 14 |
|
|
|
Invoice
Lines Flexfield Segment 15 |
|
|
|
Invoice
Transactions Flexfield Context |
|
|
|
Invoice
Transactions Flexfield Segment 1 |
|
|
|
Invoice
Transactions Flexfield Segment 2 |
|
|
|
Invoice
Transactions Flexfield Segment 3 |
|
|
|
Invoice
Transactions Flexfield Segment 4 |
|
|
|
Invoice
Transactions Flexfield Segment 5 |
|
|
|
Invoice
Transactions Flexfield Segment 6 |
|
|
|
Invoice
Transactions Flexfield Segment 7 |
|
|
|
Invoice
Transactions Flexfield Segment 8 |
|
|
|
Invoice
Transactions Flexfield Segment 9 |
|
|
|
Invoice
Transactions Flexfield Segment 10 |
|
|
|
Invoice
Transactions Flexfield Segment 11 |
|
|
|
Invoice
Transactions Flexfield Segment 12 |
|
|
|
Invoice
Transactions Flexfield Segment 13 |
|
|
|
Invoice
Transactions Flexfield Segment 14 |
|
|
|
Invoice
Transactions Flexfield Segment 15 |
|
|
|
Receivables
Transaction Region Information Flexfield Context |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 1 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 2 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 3 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 4 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 5 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 6 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 7 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 8 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 9 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 10 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 11 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 12 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 13 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 14 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 15 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 16 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 16 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 17 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 18 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 19 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 20 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 21 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 22 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 23 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 24 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 25 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 26 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 27 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 28 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 29 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 30 |
|
|
|
Line
Global Descriptive Flexfield Attribute Category |
|
|
|
Line
Global Descriptive Flexfield Segment 1 |
|
|
|
Line
Global Descriptive Flexfield Segment 2 |
|
|
|
Line
Global Descriptive Flexfield Segment 3 |
|
|
|
Line
Global Descriptive Flexfield Segment 4 |
|
|
|
Line
Global Descriptive Flexfield Segment 5 |
|
|
|
Line
Global Descriptive Flexfield Segment 6 |
|
|
|
Line
Global Descriptive Flexfield Segment 7 |
|
|
|
Line
Global Descriptive Flexfield Segment 8 |
|
|
|
Line
Global Descriptive Flexfield Segment 9 |
|
|
|
Line
Global Descriptive Flexfield Segment 10 |
|
|
|
Line
Global Descriptive Flexfield Segment 11 |
|
|
|
Line
Global Descriptive Flexfield Segment 12 |
|
|
|
Line
Global Descriptive Flexfield Segment 13 |
|
|
|
Line
Global Descriptive Flexfield Segment 14 |
|
|
|
Line
Global Descriptive Flexfield Segment 15 |
|
|
|
Line
Global Descriptive Flexfield Segment 16 |
|
|
|
Line
Global Descriptive Flexfield Segment 17 |
|
|
|
Line
Global Descriptive Flexfield Segment 18 |
|
|
|
Line
Global Descriptive Flexfield Segment 19 |
|
|
|
Line
Global Descriptive Flexfield Segment 20 |
|
|
|
Comments |
|
|
|
Notes
from Source |
|
|
|
Credit
Card Token Number |
|
|
|
Credit
Card Expiration Date |
|
|
|
First
Name of the Credit Card Holder |
|
|
|
Last
Name of the Credit Card Holder |
|
|
|
Credit
Card Issuer Code |
|
|
|
Masked
Credit Card Number |
|
|
|
Credit
Card Authorization Request Identifier |
|
|
|
Credit
Card Voice Authorization Code |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 1 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 2 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 3 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 4 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 5 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 6 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 7 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 8 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 9 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 10 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 11 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 12 |
|
|
|
Receivables
Transaction Region Information Flexfield Date Segment 1 |
|
|
|
Receivables
Transaction Region Information Flexfield Date Segment 2 |
|
|
|
Receivables
Transaction Region Information Flexfield Date Segment 3 |
|
|
|
Receivables
Transaction Region Information Flexfield Date Segment 4 |
|
|
|
Receivables
Transaction Region Information Flexfield Date Segment 5 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Number Segment 1 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Number Segment 2 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Number Segment 3 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Number Segment 4 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Number Segment 5 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Date Segment 1 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Date Segment 2 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Date Segment 3 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Date Segment 4 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Date Segment 5 |
|
|
|
Freight
Charge |
|
|
|
Insurance
Charge |
|
|
|
Packing
Charge |
|
|
|
Miscellaneous
Charge |
|
|
|
Commercial
Discount |
|
|
|
Enforce
Chronological Document Sequencing |
|
|
|
Payments
transaction identifier |
|
|
|
Interface
Status |
|
|
|
Invoice
Lines Flexfield Number Segment 1 |
|
|
|
Invoice
Lines Flexfield Number Segment 2 |
|
|
|
Invoice
Lines Flexfield Number Segment 3 |
|
|
|
Invoice
Lines Flexfield Number Segment 4 |
|
|
|
Invoice
Lines Flexfield Number Segment 5 |
|
|
|
Invoice
Lines Flexfield Date Segment 1 |
|
|
|
Invoice
Lines Flexfield Date Segment 2 |
|
|
|
Invoice
Lines Flexfield Date Segment 3 |
|
|
|
Invoice
Lines Flexfield Date Segment 4 |
|
|
|
Invoice
Lines Flexfield Date Segment 5 |
|
|
|
Invoice
Transactions Flexfield Number Segment 1 |
|
|
|
Invoice
Transactions Flexfield Number Segment 2 |
|
|
|
Invoice
Transactions Flexfield Number Segment 3 |
|
|
|
Invoice
Transactions Flexfield Number Segment 4 |
|
|
|
Invoice
Transactions Flexfield Number Segment 5 |
|
|
|
Invoice
Transactions Flexfield Date Segment 1 |
|
|
|
Invoice
Transactions Flexfield Date Segment 2 |
|
|
|
Invoice
Transactions Flexfield Date Segment 3 |
|
|
|
Invoice
Transactions Flexfield Date Segment 4 |
|
|
|
Invoice
Transactions Flexfield Date Segment 5 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 16 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 17 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 18 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 19 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 20 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 21 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 22 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 23 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 24 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 25 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 26 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 27 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 28 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 29 |
|
|
|
Receivables
Transaction Region Information Flexfield Segment 30 |
|
|
|
Line
Global Descriptive Flexfield Attribute Category |
|
|
|
Line
Global Descriptive Flexfield Segment 1 |
|
|
|
Line
Global Descriptive Flexfield Segment 2 |
|
|
|
Line
Global Descriptive Flexfield Segment 3 |
|
|
|
Line
Global Descriptive Flexfield Segment 4 |
|
|
|
Line
Global Descriptive Flexfield Segment 5 |
|
|
|
Line
Global Descriptive Flexfield Segment 6 |
|
|
|
Line
Global Descriptive Flexfield Segment 7 |
|
|
|
Line
Global Descriptive Flexfield Segment 8 |
|
|
|
Line
Global Descriptive Flexfield Segment 9 |
|
|
|
Line
Global Descriptive Flexfield Segment 10 |
|
|
|
Line
Global Descriptive Flexfield Segment 11 |
|
|
|
Line
Global Descriptive Flexfield Segment 12 |
|
|
|
Line
Global Descriptive Flexfield Segment 13 |
|
|
|
Line
Global Descriptive Flexfield Segment 14 |
|
|
|
Line
Global Descriptive Flexfield Segment 15 |
|
|
|
Line
Global Descriptive Flexfield Segment 16 |
|
|
|
Line
Global Descriptive Flexfield Segment 17 |
|
|
|
Line
Global Descriptive Flexfield Segment 18 |
|
|
|
Line
Global Descriptive Flexfield Segment 19 |
|
|
|
Line
Global Descriptive Flexfield Segment 20 |
|
|
|
Comments |
|
|
|
Notes
from Source |
|
|
|
Credit
Card Token Number |
|
|
|
Credit
Card Expiration Date |
|
|
|
First
Name of the Credit Card Holder |
|
|
|
Last
Name of the Credit Card Holder |
|
|
|
Credit
Card Issuer Code |
|
|
|
Masked
Credit Card Number |
|
|
|
Credit
Card Authorization Request Identifier |
|
|
|
Credit
Card Voice Authorization Code |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 1 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 2 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 3 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 4 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 5 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 6 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 7 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 8 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 9 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 10 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 11 |
|
|
|
Receivables
Transaction Region Information Flexfield Number Segment 12 |
|
|
|
Receivables
Transaction Region Information Flexfield Date Segment 1 |
|
|
|
Receivables
Transaction Region Information Flexfield Date Segment 2 |
|
|
|
Receivables
Transaction Region Information Flexfield Date Segment 3 |
|
|
|
Receivables
Transaction Region Information Flexfield Date Segment 4 |
|
|
|
Receivables
Transaction Region Information Flexfield Date Segment 5 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Number Segment 1 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Number Segment 2 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Number Segment 3 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Number Segment 4 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Number Segment 5 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Date Segment 1 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Date Segment 2 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Date Segment 3 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Date Segment 4 |
|
|
|
Receivables
Transaction Line Region Information Flexfield Date Segment 5 |
|
|
|
Freight
Charge |
|
|
|
Insurance
Charge |
|
|
|
Packing
Charge |
|
|
|
Miscellaneous
Charge |
|
|
|
Commercial
Discount |
|
|
|
Enforce
Chronological Document Sequencing |
|
|
|
Payments
transaction identifier |
|
|
|
Interface
Status |
|
|
|
Invoice
Lines Flexfield Number Segment 1 |
|
|
|
Invoice
Lines Flexfield Number Segment 2 |
|
|
|
Invoice
Lines Flexfield Number Segment 3 |
|
|
|
Invoice
Lines Flexfield Number Segment 4 |
|
|
|
Invoice
Lines Flexfield Number Segment 5 |
|
|
|
Invoice
Lines Flexfield Date Segment 1 |
|
|
|
Invoice
Lines Flexfield Date Segment 2 |
|
|
|
Invoice
Lines Flexfield Date Segment 3 |
|
|
|
Invoice
Lines Flexfield Date Segment 4 |
|
|
|
Invoice
Lines Flexfield Date Segment 5 |
|
|
|
Invoice
Transactions Flexfield Number Segment 1 |
|
|
|
Invoice
Transactions Flexfield Number Segment 2 |
|
|
|
Invoice
Transactions Flexfield Number Segment 3 |
|
|
|
Invoice
Transactions Flexfield Number Segment 4 |
|
|
|
Invoice
Transactions Flexfield Number Segment 5 |
|
|
|
Invoice
Transactions Flexfield Date Segment 1 |
|
|
|
Invoice
Transactions Flexfield Date Segment 2 |
|
|
|
Invoice
Transactions Flexfield Date Segment 3 |
|
|
|
Invoice
Transactions Flexfield Date Segment 4 |
|
|
|
Invoice
Transactions Flexfield Date Segment 5 |
|
|
Data to be populated in “RA_INTERFACE_DISTRIBUTIONS_ALL.”
|
FBDI Columns |
Description |
Mandatory |
|
*Business
Unit Name |
Needed
Business Unit |
|
|
*Account
Class |
Needed |
|
|
Amount |
|
|
|
Percent |
Needed |
|
|
Accounted
Amount in Ledger Currency |
|
|
|
Line
Transactions Flexfield Context |
|
|
|
Line
Transactions Flexfield Segment 1 |
|
|
|
Line
Transactions Flexfield Segment 2 |
|
|
|
Line
Transactions Flexfield Segment 3 |
|
|
|
Line
Transactions Flexfield Segment 4 |
|
|
|
Line
Transactions Flexfield Segment 5 |
|
|
|
Line
Transactions Flexfield Segment 6 |
|
|
|
Line
Transactions Flexfield Segment 7 |
|
|
|
Line
Transactions Flexfield Segment 8 |
|
|
|
Line
Transactions Flexfield Segment 9 |
|
|
|
Line
Transactions Flexfield Segment 10 |
|
|
|
Line
Transactions Flexfield Segment 11 |
|
|
|
Line
Transactions Flexfield Segment 12 |
|
|
|
Line
Transactions Flexfield Segment 13 |
|
|
|
Line
Transactions Flexfield Segment 14 |
|
|
|
Line
Transactions Flexfield Segment 15 |
|
|
|
Accounting
Flexfield Segment 1 |
Needed |
|
|
Accounting
Flexfield Segment 2 |
Needed |
|
|
Accounting
Flexfield Segment 3 |
Needed |
|
|
Accounting
Flexfield Segment 4 |
Needed |
|
|
Accounting
Flexfield Segment 5 |
Needed |
|
|
Accounting
Flexfield Segment 6 |
Needed |
|
|
Accounting
Flexfield Segment 7 |
Needed |
|
|
Accounting
Flexfield Segment 8 |
Needed |
|
|
Accounting
Flexfield Segment 9 |
Needed |
|
|
Accounting
Flexfield Segment 10 |
|
|
|
Accounting
Flexfield Segment 11 |
|
|
|
Accounting
Flexfield Segment 12 |
|
|
|
Accounting
Flexfield Segment 13 |
|
|
|
Accounting
Flexfield Segment 14 |
|
|
|
Accounting
Flexfield Segment 15 |
|
|
|
Accounting
Flexfield Segment 16 |
|
|
|
Accounting
Flexfield Segment 17 |
|
|
|
Accounting
Flexfield Segment 18 |
|
|
|
Accounting
Flexfield Segment 19 |
|
|
|
Accounting
Flexfield Segment 20 |
|
|
|
Accounting
Flexfield Segment 21 |
|
|
|
Accounting
Flexfield Segment 22 |
|
|
|
Accounting
Flexfield Segment 23 |
|
|
|
Accounting
Flexfield Segment 24 |
|
|
|
Accounting
Flexfield Segment 25 |
|
|
|
Accounting
Flexfield Segment 26 |
|
|
|
Accounting
Flexfield Segment 27 |
|
|
|
Accounting
Flexfield Segment 28 |
|
|
|
Accounting
Flexfield Segment 29 |
|
|
|
Accounting
Flexfield Segment 30 |
|
|
|
Comments |
|
|
|
Interim
Tax Segment 1 |
|
|
|
Interim
Tax Segment 2 |
|
|
|
Interim
Tax Segment 3 |
|
|
|
Interim
Tax Segment 4 |
|
|
|
Interim
Tax Segment 5 |
|
|
|
Interim
Tax Segment 6 |
|
|
|
Interim
Tax Segment 7 |
|
|
|
Interim
Tax Segment 8 |
|
|
|
Interim
Tax Segment 9 |
|
|
|
Interim
Tax Segment 10 |
|
|
|
Interim
Tax Segment 11 |
|
|
|
Interim
Tax Segment 12 |
|
|
|
Interim
Tax Segment 13 |
|
|
|
Interim
Tax Segment 14 |
|
|
|
Interim
Tax Segment 15 |
|
|
|
Interim
Tax Segment 16 |
|
|
|
Interim
Tax Segment 17 |
|
|
|
Interim
Tax Segment 18 |
|
|
|
Interim
Tax Segment 19 |
|
|
|
Interim
Tax Segment 20 |
|
|
|
Interim
Tax Segment 21 |
|
|
|
Interim
Tax Segment 22 |
|
|
|
Interim
Tax Segment 23 |
|
|
|
Interim
Tax Segment 24 |
|
|
|
Interim
Tax Segment 25 |
|
|
|
Interim
Tax Segment 26 |
|
|
|
Interim
Tax Segment 27 |
|
|
|
Interim
Tax Segment 28 |
|
|
|
Interim
Tax Segment 29 |
|
|
|
Interim
Tax Segment 30 |
|
|
|
Interface
Distributions Flexfield Context |
|
|
|
Interface
Distributions Flexfield Segment 1 |
|
|
|
Interface
Distributions Flexfield Segment 2 |
|
|
|
Interface
Distributions Flexfield Segment 3 |
|
|
|
Interface
Distributions Flexfield Segment 4 |
|
|
|
Interface
Distributions Flexfield Segment 5 |
|
|
|
Interface
Distributions Flexfield Segment 6 |
|
|
|
Interface
Distributions Flexfield Segment 7 |
|
|
|
Interface
Distributions Flexfield Segment 8 |
|
|
|
Interface
Distributions Flexfield Segment 9 |
|
|
|
Interface
Distributions Flexfield Segment 10 |
|
|
|
Interface
Distributions Flexfield Segment 11 |
|
|
|
Interface
Distributions Flexfield Segment 12 |
|
|
|
Interface
Distributions Flexfield Segment 13 |
|
|
|
Interface
Distributions Flexfield Segment 14 |
|
|
|
Interface
Distributions Flexfield Segment 15 |
|
|
Data to be
Populated in “RA_INTERFACE_SALESCREDITS_ALL.”
– (Optional Sheet)
|
FBDI Column Name |
Description |
Mandatory |
|
*Business
Unit Name |
Needed |
|
|
Salesperson
Number |
Needed |
|
|
Name of
Sales Credit Type |
Needed |
|
|
Sales
Credit Amount Split |
|
|
|
Sales
Credit Percentage Split |
Needed |
|
|
Line
Transactions Flexfield Context |
|
|
|
Line
Transactions Flexfield Segment 1 |
|
|
|
Line
Transactions Flexfield Segment 2 |
|
|
|
Line
Transactions Flexfield Segment 3 |
|
|
|
Line
Transactions Flexfield Segment 4 |
|
|
|
Line Transactions
Flexfield Segment 5 |
|
|
|
Line
Transactions Flexfield Segment 6 |
|
|
|
Line
Transactions Flexfield Segment 7 |
|
|
|
Line
Transactions Flexfield Segment 8 |
|
|
|
Line
Transactions Flexfield Segment 9 |
|
|
|
Line
Transactions Flexfield Segment 10 |
|
|
|
Line
Transactions Flexfield Segment 11 |
|
|
|
Line
Transactions Flexfield Segment 12 |
|
|
|
Line
Transactions Flexfield Segment 13 |
|
|
|
Line
Transactions Flexfield Segment 14 |
|
|
|
Line
Transactions Flexfield Segment 15 |
|
|
|
Interface
Sales Credits Flexfield Context |
|
|
|
Interface
Sales Credits Flexfield Segment 1 |
|
|
|
Interface
Sales Credits Flexfield Segment 2 |
|
|
|
Interface
Sales Credits Flexfield Segment 3 |
|
|
|
Interface
Sales Credits Flexfield Segment 4 |
|
|
|
Interface
Sales Credits Flexfield Segment 5 |
|
|
|
Interface
Sales Credits Flexfield Segment 6 |
|
|
|
Interface
Sales Credits Flexfield Segment 7 |
|
|
|
Interface
Sales Credits Flexfield Segment 8 |
|
|
|
Interface
Sales Credits Flexfield Segment 9 |
|
|
|
Interface
Sales Credits Flexfield Segment 10 |
|
|
|
Interface
Sales Credits Flexfield Segment 11 |
|
|
|
Interface
Sales Credits Flexfield Segment 12 |
|
|
|
Interface
Sales Credits Flexfield Segment 13 |
|
|
|
Interface
Sales Credits Flexfield Segment 14 |
|
|
|
Interface
Sales Credits Flexfield Segment 15 |
|
|
Comments
Post a Comment