VED_PRRT_AET(SQL Table) |
Index Back |
|---|---|
Vchr Edit Prorate AE State Tbl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 3 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 4 | SELECT_COUNT | Number(10,0) | DECIMAL(10) NOT NULL | SQL Select Count |
| 5 | TEMP_FLD | Character(1) | VARCHAR2(1) NOT NULL | Temporary Field for App Engine |
| 6 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 8 | RETURN_CD | Character(1) | VARCHAR2(1) NOT NULL |
Return Code
0=Return OK 1=Return error |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 11 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 12 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 13 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 14 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 15 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 16 | BASE_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. " |
| 17 | DECIMAL_POS_BSE | Number(2,0) | SMALLINT NOT NULL | Base Cur Decimal Positions |
| 18 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 19 | DECIMAL_POS_BUGL | Number(1,0) | SMALLINT NOT NULL | Decimal Positions for GL BU |
| 20 | DSCNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amount |
| 21 | DSCNT_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Discount |
| 22 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 23 | MERCH_AMT_DSCNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amount |
| 24 | DSCNT_AMT_DIST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amount Distrib |
| 25 | MERCH_AMT_DIST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Distribution Merchandise Amt |
| 26 | DIFFERENCE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Difference Amount |
| 27 | TOTAL_DISTRIBS | Number(5,0) | INTEGER NOT NULL | Total Number of Distributions |
| 28 | DISTRIB_MTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by
A=Amount Q=Quantity |
| 29 | 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 |
| 30 | MISC_CHARGE_CODE | Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 31 | PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate |
| 32 | PRRT_BASIS_FLD | Character(18) | VARCHAR2(18) NOT NULL | Prorate Basis Field |
| 33 | PRRT_DISTRIB_FLD | Character(18) | VARCHAR2(18) NOT NULL | Prorate Distrib Field |
| 34 | PRRT_BS_DST_FLD | Character(18) | VARCHAR2(18) NOT NULL | Prorate Basis Distrib Field |
| 35 | MISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 36 | MISC_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 37 | MISC_AMT_DIST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc Amount Distrib |
| 38 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 39 | FREIGHT_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 40 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 41 | QTY_VCHR_DIST | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered Distrib |
| 42 | VAT_CALC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
"A flag that indicates how VAT is stated and determines how the system performs the relevant VAT calculations. If ""Exclusive"", the VAT amount is stated separately from the merchandise amount. If ""Inclusive"", the VAT is not stated separately but is included with the merchandise amount."
E=Exclusive I=Inclusive |
| 43 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |
| 44 | DSCNT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Discount Amount |
| 45 | MISC_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Misc. Amount |
| 46 | FREIGHT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Freight Amount |
| 47 | SALETX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Sales Tax Amount |
| 48 | SALETX_CLC_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Calculated Sales Tax Base Amt |
| 49 | USETAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Use Tax Amount |
| 50 | MEMO_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Memo Amt Base |
| 51 | VAT_INV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amount |
| 52 | VAT_INV_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amt Base Curr |
| 53 | VAT_INV_DIST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amt Distrib |
| 54 | VAT_NONINV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Non-Invoice Amount |
| 55 | VAT_NONINV_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Non-Invoice Amt Base Curr |
| 56 | VAT_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt |
| 57 | VAT_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt in Base Curr |
| 58 | VAT_NRCVR_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Non Recoverable |
| 59 | VAT_NRCVR_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT NonRecoverable Amount |
| 60 | VAT_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the amount on a sale (receivables item) or purchase (Payables voucher) transaction that is subject to VAT taxation. Depending on other parameters this amount may represent the gross or net amount of the transaction and may or may not include freight charges. |
| 61 | VAT_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Basis Amt in Base Curr |
| 62 | VAT_BASIS_DIST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Basis Amt Distrib |
| 63 | VAT_CALC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Calculated Amount |
| 64 | VAT_CALC_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Calculated Amount Base Cur |
| 65 | VAT_REBATE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Rebate Amt |
| 66 | VAT_REBATE_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Rebate Amt in Base Curr |
| 67 | VAT_TRANS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the sale or purchase amount against which the VAT is applicable. |
| 68 | VAT_TRANS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the sale or purchase amount in base currency against which the VAT is applicable |
| 69 | VAT_DSCNT_ADJ | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Dscnt Adj |
| 70 | VAT_DSCNT_ADJ_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Discount Adjust Base Curr |
| 71 | VAT_DSCNT_RCVRY | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Dscnt Adj Rcvr |
| 72 | VAT_DSCNT_RCVR_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Discnt Recovery Base Curr |
| 73 | TAX_CD_VAT_PCT | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | Specifies the tax percentage that corresponds to the VAT code. If more than one VAT authority is linked to a VAT code this will represent an aggregate percentage. |
| 74 | DSCNT_PCT_TMP | Number(9,5) | DECIMAL(8,5) NOT NULL | Discount Percentage Temp |
| 75 | VAT_RCVRY_PCT_TMP | Signed Number(9,4) | DECIMAL(7,4) NOT NULL | VAT Recovery Percent Temp |
| 76 | SUT_APPLICABILITY | Character(1) | VARCHAR2(1) NOT NULL |
Sales/Use Tax Applicability
D=Direct Pay E=Item is Exempt S=Sales Tax Applicable U=Use Tax Applicable X=Purchaser Is Exonerated |
| 77 | TAX_VAT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include VAT
N=No Y=Yes Y/N Table Edit |
| 78 | TAX_FRGHT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include Freight
Y/N Table Edit |
| 79 | TAX_DSCNT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include Discount
Y/N Table Edit |
| 80 | TAX_MISC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Include Misc Charges
Y/N Table Edit |
| 81 | TAX_CD_SUT | Character(8) | VARCHAR2(8) NOT NULL | Tax Code - Sales and Use Tax |
| 82 | SUT_CALC_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SUT Calculation Basis Amount |
| 83 | TAX_CD_SUT_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Sales/Use Tax Code Percent |
| 84 | SALES_USE_TX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales / Use Tax Amount |
| 85 | SUT_CALC_AMT_DIST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SUT Calc Amount Distrib |
| 86 | SUT_BASIS_AMT_DIST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | SUT Basis Amount Distrib |
| 87 | SALETX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 88 | USETAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 89 | SALETX_CALC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Calculated Sales Tax Amount |
| 90 | SALETX_DIFF_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Difference |
| 91 | SALETX_TOL_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Sales Tax Tolerance Percent |
| 92 | SALETX_TOL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Tolerance Amount |
| 93 | SALETX_TOL_CUR_CD | Character(3) | VARCHAR2(3) NOT NULL | Sales Tax Tolerance Curr Code |
| 94 | SALETX_TOL_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Sales Tax Tolerance Rate Type |
| 95 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 96 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 97 | USETAX_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Use Tax |
| 98 | SALETX_CHARGE_CODE | Character(10) | VARCHAR2(10) NOT NULL | 10/8/98 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement |
| 99 | SALETX_PRORATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Prorate Sales Tax |
| 100 | DSCN_SUT_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount SUT Basis Amount |
| 101 | FRGT_SUT_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight SUT Basis Amount |
| 102 | MISC_SUT_BASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc Charge SUT Basis Amount |
| 103 | BASIS_AMT | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Withholding Basis Amount |
| 104 | DIFF_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Difference in Paid and Actual Amount |
| 105 | VAT_RVRSE_CHG_GDS | Character(1) | VARCHAR2(1) NOT NULL | VAT Reverse Charge goods flag |