BUSINESS_UNIT_APVOUCHER_IDSSF_VHDR_STG_VW(SQL View) |
Index Back |
|---|---|
Voucher Header Stage ViewVoucher Header Staging View |
| SELECT BUSINESS_UNIT ,VOUCHER_ID ,GROSS_AMT FROM PS_SSF_VCHHDR_STG |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT_AP |
Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 2 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 3 | GROSS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Invoice Amount |