BI_LC_EXT_SUM_H

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE2	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	LC_ID	Character(12)	VARCHAR2(12) NOT NULL	Treasury Letter of Credit Number Assigned by the System
4	LOC_DOC_ID	Character(30)	VARCHAR2(30) NOT NULL	Letter of Credit Document ID
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
6	RUN_DTTM	DateTime(26)	TIMESTAMP	Run Date and Time
7	NAME1	Character(40)	VARCHAR2(40) NOT NULL	Name 1
8	BILL_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Bill Status CAN=Canceled FNL=Finalized Bill HLD=Hold Bill INV=Invoiced Bill NEW=New Bill PND=Pending Approval RDY=Ready to Invoice TMP=Temporary Bill TMR=Temporary Ready Bill
9	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer
10	BI_CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Billing Currency Code
11	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract
12	UNBILLED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Unbilled Amount
13	PREV_BILLED_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Previously Billed
14	DRAW_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Available Draw
15	LIMIT_AMT_BIL	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Funded/Billing Limit Amount
16	INVOICE_DT	Date(10)	DATE	Invoice Date
17	INVOICE_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Invoice Action C=Reprint I=Invoice P=Pro Forma
18	RANGE_SELECTION_ID	Character(30)	VARCHAR2(30) NOT NULL	Range Selection ID
19	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
20	LOC_DOC_INACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Inactive Doc ID
21	SUB_ACCOUNT_NUM	Character(50)	VARCHAR2(50) NOT NULL	Subaccount ID