BI_GT_CUST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CUSTOMER_CD	Character(12)	VARCHAR2(12) NOT NULL	Customer Code, used by Golden Tax Adapter, created by SOS
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: CUST_ALL_A1_VW
4	CUST_NAME2	Character(50)	VARCHAR2(50) NOT NULL	Customer Name, used by Golden Tax Adapter, created by SOS
5	SHORT_CODE	Character(4)	VARCHAR2(4) NOT NULL	Short Code, used by Golden Tax Adapter, created by SOS
6	VAT_INVOICE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	VAT Invoice Type, used by Golden Tax Adapter, created by SOS C=Common S=Special
7	EXPORT_STATUS_GTA	Character(1)	VARCHAR2(1) NOT NULL	Export Status, used by Golden Tax Adapter, created by SOS Default Value: N
8	LAST_MODIFIED_DATE	DateTime(26)	TIMESTAMP	Last modified date
9	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance