Outbound invoice line staging table
The Outbound invoice line [sn_spend_intg_outbound_invoice_line] staging table stores important invoice line data so that an ERP integrator can export this data to a third-party ERP system.
Outbound invoice line staging table
The following table lists the mandatory fields for the Outbound invoice line [sn_spend_intg_outbound_invoice_line] staging table.
| Field | Data type | Description |
|---|---|---|
| Line description | String | Description of the invoice line. |
| Purchase order line | Reference | Information of the individual lines under a purchase order line or a sourcing request for the referenced supplier. |
| Invoice line quantity | String | The number of items that have been invoiced. |
| Line unit price | String | Unit price of the line item in the invoice. |
| Ledger account | Reference | Displays General Ledger Account. |
| Tax amount.amount | String | Tax rate applied on the invoice amount. |
| Subtotal.amount | String | Total amount of money to be paid to the supplier excluding tax and shipping charges. |
| Cost center | Reference | Represent business entity to which costs can be allocated |
| Invoice.Legal entity. ERP source | String | Stores organizational entities defined in the application |
| ERP line number | String | Displays the ERP number at the line item level |
| Invoice | Reference | Transaction record used to track purchase between shopper and supplier |
| Number | String | The number in the invoice |
| Status | Choice | Status of an invoice |
| Line amount.invoiced amount | String | The total amount for the invoice line |