AP_DCM_VCHR_HDR

(SQL View)
 Index Back

Imaging Invoice Headers

Imaging Invoices

SELECT A.BUSINESS_UNIT %Concat '.' %Concat A.VOUCHER_ID , A.BUSINESS_UNIT , A.VOUCHER_ID , B.DCM_SUPPLIER_KEY , A.VENDOR_ID , A.VNDR_LOC , A.INVOICE_ID , A.INVOICE_DT , A.GROSS_AMT , A.ACCOUNTING_DT , A.TXN_CURRENCY_CD , A.SALETX_AMT , A.FREIGHT_AMT , A.MISC_AMT , A.VAT_ENTRD_AMT , A.USETAX_AMT , A.ENTRY_STATUS , A.POST_STATUS_AP , ' ' , A.MATCH_STATUS_VCHR , A.APPR_STATUS , A.LAST_UPDATE_DT FROM PS_VOUCHER A , PS_AP_DM_BU C , PS_DCM_SUPPLIER B WHERE A.VENDOR_SETID = B.VENDOR_SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VNDR_LOC = B.VNDR_LOC AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VCHR_SRC = 'DCM'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DCM_VCHR_KEY Character(14) VARCHAR2(14) NOT NULL Voucher Id Key
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
4 DCM_SUPPLIER_KEY Character(27) VARCHAR2(27) NOT NULL Business Unit Concatenated with Supplier ID and Supplier Location to make a unique combination for third party systems.
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
7 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
8 INVOICE_DT Date(10) DATE Invoice Date
9 GROSS_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Gross Invoice Amount
10 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
11 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
12 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
13 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
14 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
15 VAT_ENTRD_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Entered VAT Amount
16 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
17 ENTRY_STATUS Character(1) VARCHAR2(1) NOT NULL If translate values are added or changed, modify the following code to make sure the values appear accurately in the dropdown list in the search dialog: VCHR_SRCH_DEL.ENTRY_STATUS.SearchInit. Template Voucher status should not be visibile in the drop down.
C=Complete
D=Through batch defaults
E=Edited by Batch Voucher Module
L=Reviewed through Maintenance
M=Modified
O=Open
P=Postable
R=Recycle
S=Scheduled for Payment
T=Template Voucher
X=Deleted
18 POST_STATUS_AP Character(1) VARCHAR2(1) NOT NULL Post Status
N=Payment Not Applied
P=Posted
U=Unposted
19 PYMNT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status
A=Alignment
E=ACH/EFT Prenote
L=Stale Dated Payment
N=Reprinted with same ref number
O=Overflow
P=Paid
R=Replaced
S=Stopped
T=Undo Escheatment
U=Undo Cancel
V=Void
W=Escheated Check
X=Deleted
20 MATCH_STATUS_VCHR Character(1) VARCHAR2(1) NOT NULL Match Status
C=Overridden - Credit Note
D=Match Dispute
E=Match Exceptions Exist
M=Matched
N=Not Applicable
O=Manually Overridden
T=To Be Matched
21 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending
22 LAST_UPDATE_DT Date(10) DATE Last Updated