BI_EIVC_HDISC

(SQL Table)
Index Back

Extract for Header Dis/Sur

# 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 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
4 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
5 IDENTIFIER_TBL Character(3) VARCHAR2(3) NOT NULL Table Identifier
A=Asset ID
CON=Contracts
D=Discount Table
G=Generic Identifier
ID=PS/Billing Charge Id
ITM=PS/Inventory Item ID
LAB=Labor type
PDA=Product Alias
PRD=PS/Product Id
PRM=PS/Promotion Code
S=Surcharge Table
SVC=Service
UPC=UPC
UPN=Universal Item ID
6 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier
7 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
8 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. "
9 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
10 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
11 VAT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of VAT associated with a transaction such as an invoice or a purchase order. In PeopleSoft Receivables this field is populated when the VAT declaration point is set to Invoice.