Tables and Key Fields for Invoices

As an administrator or implementor, understand the tables and the key fields that you must configure to support the integration.

To facilitate the data flow between multiple systems, this integration uses these staging tables to store invoice information:

• DSD Invoice

• DSD Invoice Line

DSD Invoice

Here are the key fields in the DSD Invoice (_ORACO__InvoiceDSD_c) staging table that you must configure for storing invoice header information.

Key Fields	API Name	Description
Invoice Number	RecordName	A unique alphanumeric key that identifies the invoices generated by the mobile application.
Account	__ORACO__Account_c (__ORACO__Account_Id_c)	Indicates the account that's associated with the invoice.
Shipment	__ORACO__Shipment_c (__ORACO__Shipment_Id_c)	Indicates the shipment associated with the invoice.
Process Status	__ORACO__ProcessStatus_c	Indicates whether the invoice is ready for processing. Accounting system must process only those invoices where this field value is Ready to Process.
Order Source System	__ORACO__OrderSS_c	Indicates the source application of the order associated with the invoice. The Order Source System is copied from the shipment for which the invoice was created.
Order Source System Number	__ORACO__OrderSSN_c	The source application number of the order associated with the invoice. The Order Source System Number is copied from the shipment for which the invoice was created.
Order Revision Number	__ORACO__OrderRN_c	The revision number of the order associated with the invoice.
Order Number	__ORACO__OrderNumber_c	The order number of the order associated with the invoice. This value is picked up from the shipment for which the invoice was created.
Legal Entity	__ORACO__LegalEntity_c (__ORACO__LegalEntity_Id_c)	The manufacturer legal entity for all products in an invoice.
Source System Source System Number	__ORACO__InvoiceSS_c __ORACO__InvoiceSSN_c	These are the unique user keys for an invoice record generated by the mobile application.

DSD Invoice Line

Here are the key fields in the DSD Invoice Line (_ORACO__InvoiceLineDSD_c) staging table that you must configure for storing invoice lines in the invoice.

Key Fields	API Name	Description
Invoice Line Number	RecordName	A unique alphanumeric key generated by the mobile application.
Line Number	__ORACO__InvoiceLineLN_c	A unique line number within an invoice and has a numeric value.
Invoice	__ORACO__Invoice_c (__ORACO__Invoice_Id_c)	The invoice header associated with the invoice line.
Product	__ORACO__Product_c (__ORACO__Product_Id_c)	The product for which the invoice is generated.
Quantity	__ORACO__Quantity_c	The quantity of the product invoiced.
Shipment Line	__ORACO__ShipmentLine_c (__ORACO__ShipmentLine_Id_c)	The shipment line associated with the invoice line.
Order Line Source System	__ORACO__OrderLineSS_c	The source application of the order line that's associated with the invoice line. The Order Line Source System is copied from the shipment line for which the invoice line was created. It must have the same value as the Order Source System field in the invoice header.
Order Line Source System Number	__ORACO__OrderLineSSN_c	The source application number of the order line associated with the invoice line. The Order Line Source System is copied from the shipment line for which the invoice line was created. It must have the same value as the Order - Source System Number field in the invoice header.
Order Line Revision Number	__ORACO__OrderLineRN_c	The revision number of the order line associated with the invoice line.
Order Line Number	__ORACO__OrderLineNumber_c	The number of the order line associated with the invoice line. The order line is copied from the shipment line for which the invoice line was created.
Source System Source System Number	__ORACO__InvoiceLineSS_c __ORACO__InvoiceLineSSN_c	The unique user keys for an invoice record generated by the mobile application. They must have the same values as those in the invoice header.