BI_LC_EXT_DTL

(SQL Table)
Index Back

Letter of Credit Temp Table

Letter of Credit Temporary table for report processing

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
4 LC_ID Character(12) VARCHAR2(12) NOT NULL Treasury Letter of Credit Number Assigned by the System
5 RUN_DTTM DateTime(26) TIMESTAMP Run Date and Time
6 LOC_DOC_ID Character(30) VARCHAR2(30) NOT NULL Letter of Credit Document ID
7 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
8 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
9 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
10 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
11 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
12 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
13 UNBILLED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Unbilled Amount
14 PREV_BILLED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Previously Billed
15 DRAW_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Available Draw
16 LIMIT_AMT_BIL Signed Number(28,3) DECIMAL(26,3) NOT NULL Funded/Billing Limit Amount
17 REF_AWD_NUMBER Character(25) VARCHAR2(25) NOT NULL Reference Award Number
18 INVOICE_DT Date(10) DATE Invoice Date
19 INVOICE_ACTION Character(1) VARCHAR2(1) NOT NULL Invoice Action
C=Reprint
I=Invoice
P=Pro Forma
20 RANGE_SELECTION_ID Character(30) VARCHAR2(30) NOT NULL Range Selection ID
21 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
22 SUB_ACCOUNT_NUM Character(50) VARCHAR2(50) NOT NULL Subaccount ID