PO_PRORATE_TMP(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | Character(5) | VARCHAR2(5) NOT NULL | Business Unit | |
| 3 | FRGHT_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Freight Charges |
| 4 | MISC_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Miscellaneous Charge |
| 5 | SALETX_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Sales Tax |
| 6 | USETAX_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Use Tax |
| 7 | VAT_NRCVR_PRO_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Non-Recoverable VAT |
| 8 | VAT_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate VAT |