Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
COLLECTION_IND	Indicates if this customer receivable account has been assigned to a collection agency. This will be set to yes when the collection agency count is greater than zero.	VARCHAR2(63)	RECEIVABLE_ACCOUNT	COLLECTION_COUNT	NO	NO	RECEIVABLE CUSTOMER
CUSTOMER_KEY	Key for the customer dimension.	NUMBER	ETL GENERATED	NA	NO	NO	RECEIVABLE CUSTOMER
DELINQUENCY	Delinquency code assigned to this receivable customer. This maybe blank. Typical VALUES will be 30, 60, 90 days to designate the number of days past due the balance was the last time it was evaluated.	VARCHAR2(63)	RECEIVABLE_ACCOUNT	DELINQUENCY	NO	NO	RECEIVABLE CUSTOMER
DELINQUENCY_LD	Long description for the delinquency code.	VARCHAR2(255)	RECEIVABLE_ACCOUNT	DELINQUENCY_DESC	NO	NO	RECEIVABLE CUSTOMER
DELINQUENCY_SD	Short description for the delinquency code.	VARCHAR2(255)	RECEIVABLE_ACCOUNT	DELINQUENCY_DESC	NO	NO	RECEIVABLE CUSTOMER
NSF_COUNT	Number of non-sufficient funds cheques written by this customer.	VARCHAR2(63)	RECEIVABLE_ACCOUNT	NSF_COUNTER	NO	NO	RECEIVABLE CUSTOMER
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	RECEIVABLE CUSTOMER
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	RECEIVABLE CUSTOMER

Ver: 9.0