PYAP_HDR_TAO

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
3 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
4 EXTRACT_TYPE_HDR Character(1) VARCHAR2(1) NOT NULL Extract Type
N=Non-Tax
T=Tax
5 PRIM_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Invoicing Location
6 REMIT_ADDR_SEQ_NUM Number(3,0) SMALLINT NOT NULL Remitting Location
7 REMIT_LOC Character(10) VARCHAR2(10) NOT NULL Remit to Location
8 DEFAULT_LOC Character(10) VARCHAR2(10) NOT NULL Default Location
9 PAYMENT_DT Date(10) DATE Payment Date
10 INVOICE_DT Date(10) DATE Invoice Date
11 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
12 FEDERAL_EIN Number(9,0) DECIMAL(9) NOT NULL Federal EIN
13 STATE_LOCAL_EIN Character(20) VARCHAR2(20) NOT NULL State and Local EIN
14 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit
15 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit
16 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
17 SEND_TO_AP Character(1) VARCHAR2(1) NOT NULL Send to AP
18 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