BUSINESS_UNITINVOICE_IDN=N
Y=Yes
B=Default from Business Unit
N=No
Y=Yes
SPF_INVC_HDR_VW(SQL View) |
Index Back |
|---|---|
EMC Header View createdView created for EMC for Spro for Line Details |
| SELECT H_ED.BUSINESS_UNIT , H_ED.INVOICE_ID , X1.XLATLONGNAME , H_ED.SP_VNDR_INTERNAL , H_ED.VMS_MANAGED , H_ED.INVOICE_DT , X2.XLATLONGNAME , H_ED.VENDOR_ID , H_ED.NAME1 , H_ED.VNDR_LOC , H_ED.ADDRESS_SEQ_NUM , H_ED.DESCR , H_ED.REMIT_VENDOR , H_ED.REMIT_TO_NAME , H_ED.REMIT_LOC , H_ED.REMIT_ADDR_SEQ_NUM , H_ED.DESCR_2 , H_ED.PYMNT_TERMS_CD , H_ED.DESCRSHORT , H_ED.ROW_CREATE_USER , H_ED.ROW_CREATE_DATE , H_ED.PROCESS_INSTANCE , H_ED.INV_LINE_AMT , H_ED.TAX_AMT , H_ED.INV_EXP_AMT , H_ED.TOTAL_AMT , H_ED.SP_MSP_FEE , H_ED.SP_MSP_TOTAL , H_ED.INVOICE_AMOUNT , H_ED.CURRENCY_CD , H_ED.INV_LINE_AMT_BSE , H_ED.TAX_AMT_BSE , H_ED.INV_EXP_AMT_BSE , H_ED.TOTAL_AMT_BSE , H_ED.SP_MSP_FEE_BSE , H_ED.SP_MSP_TOTAL_BSE , H_ED.INVOICE_AMOUNT_BSE , H_ED.CURRENCY_CD_BASE FROM PS_SPF_INV_MNG_VW H_ED , PS_SPF_INV_MNG_VW H , PSXLATITEM X1 , PSXLATITEM X2 WHERE X1.fieldname ='SP_SERVICE_METHOD' AND X1.fieldvalue = h.sp_service_method AND h.business_unit= h_ed.business_unit AND h.invoice_id = h_ed.invoice_id AND X1.EFFDT = ( SELECT MAX(X_ED.EFFDT) FROM PSXLATITEM X_Ed WHERE X1.FIeldname=X_Ed.fieldname AND X1.fieldvalue =X_ED.fieldvalue AND X_ED.EFFDT <= %CurrentDateIn ) AND X2.fieldname ='INVOICE_STATUS' AND X2.fieldvalue= h.invoice_status AND X2.EFFDT = ( SELECT MAX(X_ED.EFFDT) FROM PSXLATITEM X_Ed WHERE X2.FIeldname=X_Ed.fieldname AND X2.fieldvalue =X_ED.fieldvalue AND X_ED.EFFDT <= %CurrentDateIn ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | INVOICE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 3 | DESCR30 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | SP_VNDR_INTERNAL | Character(1) | VARCHAR2(1) NOT NULL |
Vendor Internal or External type
N=N Y=Yes |
| 5 | VMS_MANAGED | Character(1) | VARCHAR2(1) NOT NULL |
VMS Managed flag indicating if the work order is being managed by a Vendor Managed Service provider
B=Default from Business Unit N=No Y=Yes |
| 6 | INVOICE_DT | Date(10) | DATE | Invoice Date |
| 7 | STATUS_FIELD | Character(30) | VARCHAR2(30) NOT NULL | Payment Status |
| 8 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 9 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 10 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 11 | ADDRESS_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Address Sequence Number |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 13 | REMIT_VENDOR | Character(10) | VARCHAR2(10) NOT NULL | Remit Vendor |
| 14 | REMIT_TO_NAME | Character(40) | VARCHAR2(40) NOT NULL | Remit To Supplier Name |
| 15 | REMIT_LOC | Character(10) | VARCHAR2(10) NOT NULL | Remit to Location |
| 16 | REMIT_ADDR_SEQ_NUM | Number(5,0) | INTEGER NOT NULL | Remitting Location |
| 17 | DESCR_2 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 18 | PYMNT_TERMS_CD | Character(5) | VARCHAR2(5) NOT NULL | Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers. |
| 19 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 20 | ROW_CREATE_USER | Character(30) | VARCHAR2(30) NOT NULL | Row Added By |
| 21 | ROW_CREATE_DATE | DateTime(26) | TIMESTAMP | Row Creation Date Time |
| 22 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 23 | INV_LINE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Line Amount |
| 24 | TAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount |
| 25 | INV_EXP_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Expense Amount |
| 26 | TOTAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Amount |
| 27 | SP_MSP_FEE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Managed Service Provider Fee |
| 28 | SP_MSP_TOTAL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Amount including MSP Fee |
| 29 | INVOICE_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount |
| 30 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 31 | INV_LINE_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Invoice Line Amount |
| 32 | TAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Amount (base) |
| 33 | INV_EXP_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Expense Amount for Base Currency |
| 34 | TOTAL_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Estimated Total |
| 35 | SP_MSP_FEE_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Managed Service Provider Fee (Base Currency) |
| 36 | SP_MSP_TOTAL_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Amount including MSP Fee (Base Currency) |
| 37 | INVOICE_AMOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Invoice Amount in Base Currency |
| 38 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |