AP_ARC_VCHL_M_H(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | VOUCHER_ID |
Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 5 | VOUCHER_LINE_NUM |
Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 6 | DST_ACCT_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | 07/20/04 st: added RCN for Advance Reconciliation 02/16/98 ebn CN#CM800-2.0 : Added for MISC type for Landed Cost Enhancement 11/11/99 llr: Added ADVP for Payables Advance Payment |
| 7 | MISC_CHARGE_CODE |
Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 8 | COPY_PO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Copy PO Flg
Y/N Table Edit Default Value: N |
| 9 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 10 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |
| 11 | UNIT_PRICE_CNVT | Number(16,5) | DECIMAL(15,5) NOT NULL | Unit Price Converted |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 13 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 14 | UOM_VCHR | Character(3) | VARCHAR2(3) NOT NULL | Unit Of Measure Voucher |
| 15 | BASIS_AMT | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Withholding Basis Amount |
| 16 | MISC_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 17 | MISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 18 | PCT_ALLOC | Number(3,0) | SMALLINT NOT NULL |
Allocation Percentage
Default Value: 0 |
| 19 | PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Prorate
Y/N Table Edit |
| 20 | MISC_CHG_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Apply Miscellaneous Charges
Y/N Table Edit Default Value: Y |
| 21 | LC_COMP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 22 | LC_COMP_ALLOC | Character(3) | VARCHAR2(3) NOT NULL |
10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
MAT=Matl Value QTY=Quantity VOL=Volume WT=Weight |
| 23 | LC_EXTRCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Landed Cost Extract Status
Default Value: N |