BI_LC_EXT_DTL(SQL Table) |
Index Back |
---|---|
Letter of Credit Temp TableLetter 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 |