INSTALL_ACT_FD(SQL Table) |
Index Back |
|---|---|
Federal DATA ActFederal DATA Act. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACT_PROC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Enable Procurement Fields flag.
Y/N Table Edit Default Value: N |
| 2 | ACT_PROC_PROD | Character(3) | VARCHAR2(3) NOT NULL |
Federal Data act Procurement product.
G=GL P=PO PG=PO and GL |
| 3 | ACT_PIID | Number(2,0) | SMALLINT NOT NULL | PIID and Parent PIID Display Length |
| 4 | ACT_ASSIST_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Federal data act Financial Assistance Fields flag.
Y/N Table Edit Default Value: N |
| 5 | ACT_ASSIST_PROD | Character(3) | VARCHAR2(3) NOT NULL |
Federal data act financial assistance product.
G=GL P=PO PG=PO and GL |
| 6 | ACT_FAIN | Number(2,0) | SMALLINT NOT NULL | FAIN Display Length. |
| 7 | ACT_URI | Number(2,0) | SMALLINT NOT NULL | URI Display Length. |
| 8 | GNV_FLG | Character(1) | VARCHAR2(1) NOT NULL |
G-Invoicing
N=No Y=Yes |
| 9 | GNV_JRNL_VOUCHER | Character(1) | VARCHAR2(1) NOT NULL |
Create Journal Voucher for G-Invoicing Advance Adjustments.
N=Don't Generate AP Journal Vchr Y=Generate AP Journal Voucher |