BI_LINE_DSL_TMP

(SQL Table)
Index Back

Bill Line Disc Surch Lvl Tmp

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
3 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
4 DISC_SUR_LVL Number(2,0) SMALLINT NOT NULL Discount/Surcharge Level
5 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
6 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
7 CURRENCY_CD_XEU Character(3) VARCHAR2(3) NOT NULL Euro Currency
8 LVL_SUBTOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL Level Subtotal
9 TOTAL_LVL_DISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Level Discount Total
10 TOTAL_LVL_SUR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Level Surcharge Total
11 LVL_SUBTOTAL_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Level Subtotal
12 TOTAL_LVL_DISC_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Level Discount Total
13 TOTAL_LVL_SUR_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Level Surcharge Total
14 LVL_SUBTOTAL_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Level Subtotal
15 TOTAL_LVL_DISC_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Level Discount Total
16 TOTAL_LVL_SUR_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Level Surcharge Total
17 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added
18 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
19 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID