SETIDPrompt Table: SETID_TBL
VENDOR_IDINVOICE_IDN=Non-Tax
T=Tax
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: N
AP_EXTRACT_HDR(SQL Table) |
Index Back |
|---|---|
Accounts Payable Extract HdrThis record contains the output of all extract programs. This information is used to create vouchers which are sent to Accounts Payable. |
| # | 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
Y/N Table Edit Default Value: Y |
| 18 | VOUCHER_SENT | Character(1) | VARCHAR2(1) NOT NULL |
Flag to determine if the voucher has been sent to AP.
Y/N Table Edit Default Value: N |