Tables and Key Fields for Credit Lines

As a sales administrator, you can use the tables and the key fields to support the integration.

To facilitate the data flow between multiple systems, this integration uses the following staging tables to store credit line and credit note information:

• DSD Credit Line

• DSD Credit Note

DSD Credit Line

Use the following table and the key fields in the DSD Credit Line (__ORACO__CreditLineDSD_c) staging table.

Key Fields	API Name	Description
Credit Line Number	RecordName	An external ERP data source issues the Credit Line Number.
Source System Source System Number	__ORACO__CreditLineSS_c __ORACO__CreditLineSSN_c	The user keys for a credit line.
Account	__ORACO__Account_c (__ORACO__Account_Id_c)	The account for which the credit line was approved.
Credit Limit	__ORACO__CreditLimit_c	The maximum amount the customer can use with this credit line.
Number of Notes Allowed	__ORACO__NoOfNotesAllowed_c	The number of credit notes allowed with the credit line.
Amount Used	__ORACO__AmountUsed_c	The amount the customer has used with this credit line.
Notes in Use	__ORACO__NotesInUse_c	The number of credit notes opened with the credit line.
Available Credit	__ORACO__AvailableCredit_c	The available amount the customer can use with the credit line.
Balance Date	__ORACO__BalanceDate_c	The date on which the balance is updated.
Amount Due	__ORACO__AmountDue_c	The amount due with the credit line.
Legal Entity	__ORACO__LegalEntity_c (__ORACO__LegalEntity_Id_c)	The legal entity for the credit line.
Type		Indicates the type of the credit line record. The type can be standard credit line or proof of purchase.
Approved From Date		The date from which the record is valid.
Approved To Date		The date up to which the record is valid.

DSD Credit Note

Use the following table and the key fields in the DSD Credit Note (__ORACO__CreditNoteDSD_c) staging table.

Key Fields	API Name	Description
Note Number	RecordName	An external ERP data source issues the note number.
Account	__ORACO__Account_c (__ORACO__Account_Id_c)	The account for which the credit note was created.
Credit Line	__ORACO__CreditLine_c (__ORACO__CreditLine_Id_c)	The parent credit line.
Source System Source System Number Line Number	__ORACO__CreditNoteSS_c __ORACO__CreditNoteSSN_c __ORACO__CreditNoteLN_c	The user keys for a credit note.
Order Number Order - Source System Number Order Source System Order - Revision Number	__ORACO__OrderNumber_c __ORACO__OrderSSN_c __ORACO__OrderSS_c __ORACO__OrderRN_c	Identifies the order for which the credit note was opened.
Issue Date	__ORACO__IssueDate_c	The date when the credit note was opened.
Due Date	__ORACO__DueDate_c	The date when the credit note is due.
Amount	__ORACO__Account_c (__ORACO__Account_Id_c)	The amount used with the credit note.
Balance	__ORACO__Balance_c	The outstanding amount from the credit note.
Balance Date	__ORACO__BalanceDate_c	The date on which the balance is updated.
Legal Entity	__ORACO__LegalEntity_c (__ORACO__LegalEntity_Id_c)	The legal entity for the credit note.