BI_XLN_FR_VW

(SQL View)
 Index Back

BI LINE Freight Data for XML


SELECT B.SETID , B.CUST_ID , A.BUSINESS_UNIT , A.INVOICE , A.LINE_SEQ_NUM , A.INVOICE_LINE , A.CHARGE_FROM_DT , A.CHARGE_TO_DT , A.IDENTIFIER , A.DESCR , A.UNIT_OF_MEASURE , A.QTY , A.UNIT_AMT , A.GROSS_EXTENDED_AMT , A.GROSS_EXTENDED_XEU , A.NET_EXTENDED_AMT , A.NET_EXTENDED_XEU , A.TOT_DISCOUNT_AMT , A.TOT_DISCOUNT_XEU , A.TOT_SURCHARGE_AMT , A.TOT_SURCHARGE_XEU , A.TAX_AMT , A.TAX_AMT_XEU , A.TAX_PCT , A.TAX_CD , A.TAX_EXEMPT_CERT , A.TAX_EXEMPT_FLG , A.PO_REF , A.PO_LINE , A.CONTRACT_NUM , A.CONTRACT_DT , A.CONTRACT_TYPE , A.BI_CURRENCY_CD , A.CURRENCY_CD_XEU , A.PROCESS_INSTANCE , A.AUDIT_ACTN , A.IN_PROCESS_FLG FROM PS_BI_XLN_FR_TAO A , PS_BI_XHDR_TAO B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INVOICE = B.INVOICE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
5 LINE_SEQ_NUM Number(5,0) INTEGER NOT NULL Sequence
6 INVOICE_LINE Number(5,0) INTEGER NOT NULL Invoice Line
7 CHARGE_FROM_DT Date(10) DATE From Date for line charges
8 CHARGE_TO_DT Date(10) DATE Through date for charges
9 IDENTIFIER Character(18) VARCHAR2(18) NOT NULL Identifier
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
12 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
13 UNIT_AMT Signed Number(17,4) DECIMAL(15,4) NOT NULL Unit Price
14 GROSS_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
15 GROSS_EXTENDED_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Extended
16 NET_EXTENDED_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amt
17 NET_EXTENDED_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Net Extended Amount
18 TOT_DISCOUNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amt
19 TOT_DISCOUNT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Line Discount Amount
20 TOT_SURCHARGE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Surcharge Amt
21 TOT_SURCHARGE_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Surcharge Amount
22 TAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount
23 TAX_AMT_XEU Signed Number(28,3) DECIMAL(26,3) NOT NULL Tax Amount - Euro
24 TAX_PCT Number(7,4) DECIMAL(6,4) NOT NULL Tax Percent
25 TAX_CD Character(8) VARCHAR2(8) NOT NULL Tax Code
26 TAX_EXEMPT_CERT Character(30) VARCHAR2(30) NOT NULL Exemption Certificate
27 TAX_EXEMPT_FLG Character(1) VARCHAR2(1) NOT NULL Tax Exempt Flag
28 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
29 PO_LINE Number(3,0) SMALLINT NOT NULL Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF.
30 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
31 CONTRACT_DT Date(10) DATE Contract Date
32 CONTRACT_TYPE Character(15) VARCHAR2(15) NOT NULL Contract Type
33 BI_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Billing Currency Code
34 CURRENCY_CD_XEU Character(3) VARCHAR2(3) NOT NULL Euro Currency
35 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
36 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
37 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In process flag