CC_TRANLN_TEO2(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for CC_TRANS_LINE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | CREDIT_CARD_VENDOR | Character(5) | VARCHAR2(5) NOT NULL | Corporate Card Vendor |
| 4 | CRDMEM_ACCT_NBR | Character(44) | VARCHAR2(44) NOT NULL | Cardmember Number |
| 5 | TRANS_NBR | Character(24) | VARCHAR2(24) NOT NULL | Transaction Number |
| 6 | SEQUENCENO | Number(10,0) | DECIMAL(10) NOT NULL | Sequence Number |
| 7 | TRANS_DT | Date(10) | DATE NOT NULL | Transaction Date |
| 8 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 9 | DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 10 | POST_DT | Date(10) | DATE | The Date a transaction was Posted. |
| 11 | BILLING_DATE | Date(10) | DATE | Billing Date |
| 12 | CC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Statement Status
0=Staged 1=Initial 2=Verified 3=Approved 4=Closed 5=Error 6=Processing |
| 13 | SIC_CODE | Character(10) | VARCHAR2(10) NOT NULL | Standard Industry Code |
| 14 | MERCHANT | Character(40) | VARCHAR2(40) NOT NULL | Merchant |
| 15 | MERCHANT_REF | Character(30) | VARCHAR2(30) NOT NULL | Reference Number |
| 16 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 17 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 18 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 19 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 20 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 21 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 22 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 23 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 24 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
| 25 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 26 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 27 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 28 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 29 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: %EDIT_STATE |
| 30 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 31 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 32 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 33 | TAXPAYER_ID | Character(14) | VARCHAR2(14) NOT NULL | Taxpayer ID |
| 34 | ITM_ID_VNDR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
| 35 | COMMODITY_CD | Character(10) | VARCHAR2(10) NOT NULL | Commodity Code |
| 36 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 37 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 38 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 39 | DISTRIB_MTHD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Distribute by
A=Amount Q=Quantity |
| 40 | CHARGE_CATEGORY | Character(3) | VARCHAR2(3) NOT NULL |
Transaction Charge Type
1=New Charge 2=Other Debits 4=Payment 5=Other Credits |
| 41 | INCLUDE_TAX | Character(1) | VARCHAR2(1) NOT NULL |
Bill Includes Tax if Applied
Y/N Table Edit |
| 42 | TAX_PAID | Character(1) | VARCHAR2(1) NOT NULL |
Tax Paid
Y/N Table Edit |
| 43 | QTY_PO | Number(16,4) | DECIMAL(15,4) NOT NULL | Purchase Order Quantity |
| 44 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |
| 45 | TXN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Transaction Amount |
| 46 | TXN_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Transaction Currency |
| 47 | PRICE_PO | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Purchase Order Price |
| 48 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 49 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 50 | CUR_RT_TYPE_BNK | Character(5) | VARCHAR2(5) NOT NULL | Currency Rate Type |
| 51 | CUR_EXCHNG_RT | Number(16,8) | DECIMAL(15,8) NOT NULL | Currency Exchange Rate |
| 52 | CORP_ACCT_NBR | Character(20) | VARCHAR2(20) NOT NULL | Corporate Number |
| 53 | CREDIT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Date Init Ref# Descr 112007 LAKM 1717216002 Changed the filed type to enter credit value for Dispute amount field |
| 54 | CREDIT_COLLECTED | Character(1) | VARCHAR2(1) NOT NULL |
Credit Collected
Y/N Table Edit |
| 55 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 56 | VENDOR_SETID | Character(5) | VARCHAR2(5) NOT NULL | Vendor SetID |
| 57 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 58 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |
| 59 | VENDOR_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Vendor Type
ADV=Ads CNS=Consultant CNT=Contractor ENT=Entertain FRG=Foreign GVT=Government MNR=Minority PR=PR TRD=Tradesman TRN=Transport TRV=Travel |
| 60 | ITM_SETID | Character(5) | VARCHAR2(5) NOT NULL | Item SetID |
| 61 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 62 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 63 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |
| 64 | CURRENCY_CD_BASE | Character(3) | VARCHAR2(3) NOT NULL | Business Unit Base Currency |
| 65 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical. |
| 66 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 67 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 68 | OPRID_ENTERED_BY | Character(30) | VARCHAR2(30) NOT NULL | Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes |
| 69 | ENTERED_DT | Date(10) | DATE | Entered on |
| 70 | OPRID_APPROVED_BY | Character(30) | VARCHAR2(30) NOT NULL | Approved By |
| 71 | APPROVAL_DT | Date(10) | DATE | Date of Approval |
| 72 | OPRID_MODIFIED_BY | Character(30) | VARCHAR2(30) NOT NULL | Last User to Modify Entered By 07/25/2011:Ensured that OPRID_MODIFIED_BY is set with format type of MixedCase. |
| 73 | LAST_DTTM_UPDATE | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 74 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 75 | COMMENT_ID | DateTime(26) | TIMESTAMP | DtTm Entered |
| 76 | RANDOM_CMMT_NBR | Number(4,0) | SMALLINT NOT NULL | Random Comments Number |
| 77 | 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 |
| 78 | SUT_BASE_ID | Character(10) | VARCHAR2(10) NOT NULL | Sales/Use Tax Destination |
| 79 | SUT_EXCPTN_CERTIF | Character(20) | VARCHAR2(20) NOT NULL | Sales/Use Tax Exception Certif |
| 80 | SUT_EXCPTN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Sales/Use Tax Exception Type
D=Direct Pay E=Exempt/Exonerated N=None |
| 81 | TAX_CD_SUT | Character(8) | VARCHAR2(8) NOT NULL | Tax Code - Sales and Use Tax |
| 82 | TAX_CD_SUT_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Sales/Use Tax Code Percent |
| 83 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 84 | BUDGET_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid Default Value: V |
| 85 | KK_AMOUNT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control Amount Type
0=Budget 1=Actuals and Recognized 2=Encumbrance 3=Pre-Encumbrance 4=Collected Revenue 5=Planned 7=Actuals, Recognize and Collect 9=Dynamic |
| 86 | KK_TRAN_OVER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No Y=Yes |
| 87 | KK_TRAN_OVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Commitment Control source transaction override operator |
| 88 | KK_TRAN_OVER_DTTM | DateTime(26) | TIMESTAMP | Commitment Control source transaction override datetime |
| 89 | CHRTFLD_HDR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Chartfield Status
R=Recycled V=Valid |
| 90 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 91 | PO_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Purchase Order Line Number |
| 92 | PO_SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | PO Schedule Number |
| 93 | CC_ORIGINAL_PO | Character(1) | VARCHAR2(1) NOT NULL |
Original PO
Y/N Table Edit |
| 94 | MERCHANT_CAT_CODE | Character(10) | VARCHAR2(10) NOT NULL | MCC - Merchant Category Code |
| 95 | INVOICE_ID | Character(30) | VARCHAR2(30) NOT NULL | Invoice Number |
| 96 | BUSINESS_UNIT_AP | Character(5) | VARCHAR2(5) NOT NULL | AP Business Unit |
| 97 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 98 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 99 | MERCHANT_UOM | Character(20) | VARCHAR2(20) NOT NULL | Merchant UOM |
| 100 | USER_HDR_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 101 | CUSTOM_C100_A1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 102 | CUSTOM_C100_A2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 103 | CUSTOM_C100_A3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 104 | CUSTOM_C100_A4 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 4 |
| 105 | CUSTOM_DATE_A | Date(10) | DATE | Custom Date |
| 106 | CUSTOM_C1_A | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |
| 107 | USER_LINE_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 108 | CUSTOM_C100_B1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 109 | CUSTOM_C100_B2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 110 | CUSTOM_C100_B3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 111 | CUSTOM_C100_B4 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 4 |
| 112 | CUSTOM_DATE_B | Date(10) | DATE | Custom Date |
| 113 | CUSTOM_C1_B | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |
| 114 | USER_SCHED_CHAR1 | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 1 |
| 115 | CUSTOM_C100_C1 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 1 |
| 116 | CUSTOM_C100_C2 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 2 |
| 117 | CUSTOM_C100_C3 | Character(100) | VARCHAR2(100) NOT NULL | Custom Field 3 |
| 118 | CUSTOM_DATE_C1 | Date(10) | DATE | Custom Date 1 |
| 119 | CUSTOM_DATE_C2 | Date(10) | DATE | Custom Date 2 |
| 120 | CUSTOM_C1_C | Character(1) | VARCHAR2(1) NOT NULL | Custom Character 2 |
| 121 | VAT_ENTITY | Character(20) | VARCHAR2(20) NOT NULL | Specifies an organizational entity that is responsible for VAT reporting and that is registered in one or more countries that require VAT reporting. A single VAT entity is linked to one or more General Ledger Business Units depending on the reporting requirements. |
| 122 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 123 | VAT_CREDIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Claiming Tax Credit |
| 124 | VAT_RECEIPT | Character(1) | VARCHAR2(1) NOT NULL | No VAT Receipt |
| 125 | TAX_CREDIT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Date Init Ref# Descr 112007 LAKM 1717216001 Changed the filed type to enter credit value for Disput tax amount field |
| 126 | VAT_TOL_ERROR | Character(1) | VARCHAR2(1) NOT NULL | VAT Tolerance Error |
| 127 | REDISTRIB_PB | Character(1) | VARCHAR2(1) NOT NULL |
Redistribute
Y/N Table Edit |
| 128 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |