VCHR_CORR_WS3(SQL Table) |
Index Back |
---|---|
Voucher Line Misc Charge |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
2 | 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 |
3 | MISC_CHARGE_CODE | Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
4 | COPY_PO_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Copy PO Flg
Default Value: N |
5 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
6 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |
7 | UNIT_PRICE_CNVT | Number(16,5) | DECIMAL(15,5) NOT NULL | Unit Price Converted |
8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
9 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
10 | UOM_VCHR | Character(3) | VARCHAR2(3) NOT NULL | Unit Of Measure Voucher |
11 | BASIS_AMT | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Withholding Basis Amount |
12 | MISC_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
13 | MISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
14 | PCT_ALLOC | Number(3,0) | SMALLINT NOT NULL | Allocation Percentage |
15 | PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Prorate
Y/N Table Edit |
16 | MISC_CHG_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Apply Miscellaneous Charges
Y/N Table Edit Default Value: Y |
17 | LC_COMP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
18 | 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 |
19 | LC_EXTRCT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Landed Cost Extract Status
Default Value: N |