TEMPLATE_IDY/N Table Edit
BI_LN_TMPLT_WRK(SQL Table) |
Index Back |
|---|---|
Chartfield Config TemplateThis record stores Chartfield configurations. - It affects how grids are displayed on chartfield entry panels. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Project Template |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | UOM_1SW | Character(1) | VARCHAR2(1) NOT NULL |
Unit of Measure
Y/N Table Edit |
| 4 | UOM_2SW | Character(1) | VARCHAR2(1) NOT NULL | Unit of Measure |
| 5 | UNIT_AMT_1SW | Character(1) | VARCHAR2(1) NOT NULL | Unit Price |
| 6 | UNIT_AMT_2SW | Character(1) | VARCHAR2(1) NOT NULL | Unit Price |
| 7 | GROSS_EXT_AMT_1SW | Character(1) | VARCHAR2(1) NOT NULL | Gross Extended Amount |
| 8 | GROSS_EXT_AMT_2SW | Character(1) | VARCHAR2(1) NOT NULL | Gross Extended Amount |
| 9 | TOT_DISCOUNT_1SW | Character(1) | VARCHAR2(1) NOT NULL | Total Discount Amount |
| 10 | TOT_DISCOUNT_2SW | Character(1) | VARCHAR2(1) NOT NULL | Total Discount Amount |
| 11 | INSTALL_GROSS_1SW | Character(1) | VARCHAR2(1) NOT NULL | Installment Gross |
| 12 | INSTALL_GROSS_2SW | Character(1) | VARCHAR2(1) NOT NULL | Installment Gross |
| 13 | TOT_SURCHARGE_1SW | Character(1) | VARCHAR2(1) NOT NULL | Total Surcharge Amount |
| 14 | TOT_SURCHARGE_2SW | Character(1) | VARCHAR2(1) NOT NULL | Total Surcharge Amount |
| 15 | INSTALL_NET_1SW | Character(1) | VARCHAR2(1) NOT NULL | Installment Net |
| 16 | INSTALL_NET_2SW | Character(1) | VARCHAR2(1) NOT NULL | Installment Net |
| 17 | NET_EXT_AMT_1SW | Character(1) | VARCHAR2(1) NOT NULL | Net Extended Amount |
| 18 | NET_EXT_AMT_2SW | Character(1) | VARCHAR2(1) NOT NULL | Net Extended Amount |
| 19 | VAT_AMT_1SW | Character(1) | VARCHAR2(1) NOT NULL | VAT Amount |
| 20 | VAT_AMT_2SW | Character(1) | VARCHAR2(1) NOT NULL | VAT Amount |
| 21 | TAX_AMT_1SW | Character(1) | VARCHAR2(1) NOT NULL | Tax Amount |
| 22 | TAX_AMT_2SW | Character(1) | VARCHAR2(1) NOT NULL | Tax Amount |
| 23 | NET_PLUS_TAX_1SW | Character(1) | VARCHAR2(1) NOT NULL | Net Plus Tax |
| 24 | NET_PLUS_TAX_2SW | Character(1) | VARCHAR2(1) NOT NULL | Net Plus Tax |
| 25 | LINE_TYPE_1SW | Character(1) | VARCHAR2(1) NOT NULL | Line Type |
| 26 | LINE_TYPE_2SW | Character(1) | VARCHAR2(1) NOT NULL | Line Type |
| 27 | ACCUMULATE_1SW | Character(1) | VARCHAR2(1) NOT NULL | Accumulate |
| 28 | ACCUMULATE_2SW | Character(1) | VARCHAR2(1) NOT NULL | Accumulate |
| 29 | CHARGE_FR_DT_1SW | Character(1) | VARCHAR2(1) NOT NULL | From Date |
| 30 | CHARGE_FR_DT_2SW | Character(1) | VARCHAR2(1) NOT NULL | From Date |
| 31 | CHARGE_TO_DT_1SW | Character(1) | VARCHAR2(1) NOT NULL | To Date |
| 32 | CHARGE_TO_DT_2SW | Character(1) | VARCHAR2(1) NOT NULL | To Date |
| 33 | TAX_CD_1SW | Character(1) | VARCHAR2(1) NOT NULL | Tax Code |
| 34 | TAX_CD_2SW | Character(1) | VARCHAR2(1) NOT NULL | Tax Code |
| 35 | TAX_EXEMPT_1SW | Character(1) | VARCHAR2(1) NOT NULL | Tax Exempt |
| 36 | TAX_EXEMPT_2SW | Character(1) | VARCHAR2(1) NOT NULL | Tax Exempt |
| 37 | TAX_EXMPT_CERT_1SW | Character(1) | VARCHAR2(1) NOT NULL | Exempt Cert |
| 38 | TAX_EXMPT_CERT_2SW | Character(1) | VARCHAR2(1) NOT NULL | Exempt Cert |
| 39 | ERROR_STAT_BI_1SW | Character(1) | VARCHAR2(1) NOT NULL | Error Status |
| 40 | ERROR_STAT_BI_2SW | Character(1) | VARCHAR2(1) NOT NULL | Error Status |
| 41 | ERR_STAT_DESCR_1SW | Character(1) | VARCHAR2(1) NOT NULL | Error Status Descr |
| 42 | ERR_STAT_DESCR_2SW | Character(1) | VARCHAR2(1) NOT NULL | Error Status Descr |
| 43 | SYSTEM_SOURCE_1SW | Character(1) | VARCHAR2(1) NOT NULL | System Source |
| 44 | SYSTEM_SOURCE_2SW | Character(1) | VARCHAR2(1) NOT NULL | System Source |
| 45 | ENTRY_TYPE_1SW | Character(1) | VARCHAR2(1) NOT NULL | Entry Type |
| 46 | ENTRY_TYPE_2SW | Character(1) | VARCHAR2(1) NOT NULL | Entry Type |
| 47 | ENTRY_REASON_1SW | Character(1) | VARCHAR2(1) NOT NULL | Entry Reason |
| 48 | ENTRY_REASON_2SW | Character(1) | VARCHAR2(1) NOT NULL | Entry Reason |
| 49 | SUBCUST1_1SW | Character(1) | VARCHAR2(1) NOT NULL | Subcust Qualifier 1 |
| 50 | SUBCUST1_2SW | Character(1) | VARCHAR2(1) NOT NULL | Subcust Qualifier 1 |
| 51 | SUBCUST2_1SW | Character(1) | VARCHAR2(1) NOT NULL | Subcust Qualifier 2 |
| 52 | SUBCUST2_2SW | Character(1) | VARCHAR2(1) NOT NULL | Subcust Qualifier 2 |
| 53 | REV_RECOG_1SW | Character(1) | VARCHAR2(1) NOT NULL | Revenue Recognition Basis |
| 54 | REV_RECOG_2SW | Character(1) | VARCHAR2(1) NOT NULL | Revenue Recognition Basis |
| 55 | PRICE_RECAL_1SW | Character(1) | VARCHAR2(1) NOT NULL | Price Recalculation Flag |
| 56 | PRICE_RECAL_2SW | Character(1) | VARCHAR2(1) NOT NULL | Price Recalculation Flag |
| 57 | PO_REF_1SW | Character(1) | VARCHAR2(1) NOT NULL | Purchase Order/PO Line |
| 58 | PO_REF_2SW | Character(1) | VARCHAR2(1) NOT NULL | Purchase Order/PO Line |
| 59 | PO_LINE_1SW | Character(1) | VARCHAR2(1) NOT NULL | Purchase Order Line Item |
| 60 | PO_LINE_2SW | Character(1) | VARCHAR2(1) NOT NULL | Purchase Order Line Item |
| 61 | PRODUCT_ID_1SW | Character(1) | VARCHAR2(1) NOT NULL | Product Id |
| 62 | PRODUCT_ID_2SW | Character(1) | VARCHAR2(1) NOT NULL | Product Id |
| 63 | PROD_KIT_1SW | Character(1) | VARCHAR2(1) NOT NULL | Product Kit Id |
| 64 | PROD_KIT_2SW | Character(1) | VARCHAR2(1) NOT NULL | Product Kit Id |
| 65 | BU_OM_1SW | Character(1) | VARCHAR2(1) NOT NULL | Business Unit OM |
| 66 | BU_OM_2SW | Character(1) | VARCHAR2(1) NOT NULL | Business Unit OM |
| 67 | ORDER_NO_1SW | Character(1) | VARCHAR2(1) NOT NULL | Order No |
| 68 | ORDER_NO_2SW | Character(1) | VARCHAR2(1) NOT NULL | Order No |
| 69 | ORD_LINE_NO_1SW | Character(1) | VARCHAR2(1) NOT NULL | Order Line |
| 70 | ORD_LINE_NO_2SW | Character(1) | VARCHAR2(1) NOT NULL | Order Line |
| 71 | ORDER_INFO_HYP_1SW | Character(1) | VARCHAR2(1) NOT NULL | Order Info Hyperlink |
| 72 | ORDER_INFO_HYP_2SW | Character(1) | VARCHAR2(1) NOT NULL | Order Info Hyperlink |
| 73 | BI_OM_PRICE_PB_1SW | Character(1) | VARCHAR2(1) NOT NULL | OM Price Adjust |
| 74 | BI_OM_PRICE_PB_2SW | Character(1) | VARCHAR2(1) NOT NULL | OM Price Adjust |
| 75 | ORD_HNOTE_PB_1SW | Character(1) | VARCHAR2(1) NOT NULL | Order Hdr Note |
| 76 | ORD_HNOTE_PB_2SW | Character(1) | VARCHAR2(1) NOT NULL | Order Hdr Note |
| 77 | DIST_CFG_FLAG_1SW | Character(1) | VARCHAR2(1) NOT NULL | Configured Product |
| 78 | DIST_CFG_FLAG_2SW | Character(1) | VARCHAR2(1) NOT NULL | Configured Product |
| 79 | PROD_KIT_HYP_1SW | Character(1) | VARCHAR2(1) NOT NULL | Product Kit Info |
| 80 | PROD_KIT_HYP_2SW | Character(1) | VARCHAR2(1) NOT NULL | Product Kit Info |
| 81 | SCHED_LINE_NBR_1SW | Character(1) | VARCHAR2(1) NOT NULL | Sched Line |
| 82 | SCHED_LINE_NBR_2SW | Character(1) | VARCHAR2(1) NOT NULL | Sched Line |
| 83 | SCHED_SEQ_NBR_1SW | Character(1) | VARCHAR2(1) NOT NULL | Sched Line Seq |
| 84 | SCHED_SEQ_NBR_2SW | Character(1) | VARCHAR2(1) NOT NULL | Sched Line Seq |
| 85 | BU_RMA_1SW | Character(1) | VARCHAR2(1) NOT NULL | RMA Bus Unit |
| 86 | BU_RMA_2SW | Character(1) | VARCHAR2(1) NOT NULL | RMA Bus Unit |
| 87 | RMA_ID_1SW | Character(1) | VARCHAR2(1) NOT NULL | RMA Number |
| 88 | RMA_ID_2SW | Character(1) | VARCHAR2(1) NOT NULL | RMA Number |
| 89 | RMA_LINE_NBR_1SW | Character(1) | VARCHAR2(1) NOT NULL | RMA Line Number |
| 90 | RMA_LINE_NBR_2SW | Character(1) | VARCHAR2(1) NOT NULL | RMA Line Number |
| 91 | RMA_INFO_1SW | Character(1) | VARCHAR2(1) NOT NULL | RMA Info |
| 92 | RMA_INFO_2SW | Character(1) | VARCHAR2(1) NOT NULL | RMA Info |
| 93 | SHIP_DATE_1SW | Character(1) | VARCHAR2(1) NOT NULL | Ship Date |
| 94 | SHIP_DATE_2SW | Character(1) | VARCHAR2(1) NOT NULL | Ship Date |
| 95 | SHIP_TIME_1SW | Character(1) | VARCHAR2(1) NOT NULL | Ship Time |
| 96 | SHIP_TIME_2SW | Character(1) | VARCHAR2(1) NOT NULL | Ship Time |
| 97 | SHIP_FROM_BU_1SW | Character(1) | VARCHAR2(1) NOT NULL | Ship Unit |
| 98 | SHIP_FROM_BU_2SW | Character(1) | VARCHAR2(1) NOT NULL | Ship Unit |
| 99 | SHIP_ID_1SW | Character(1) | VARCHAR2(1) NOT NULL | Shipping ID |
| 100 | SHIP_ID_2SW | Character(1) | VARCHAR2(1) NOT NULL | Shipping ID |
| 101 | FREIGHT_TERMS_1SW | Character(1) | VARCHAR2(1) NOT NULL | Freight Terms |
| 102 | FREIGHT_TERMS_2SW | Character(1) | VARCHAR2(1) NOT NULL | Freight Terms |
| 103 | SHIP_TYPE_ID_1SW | Character(1) | VARCHAR2(1) NOT NULL | Ship Type Id |
| 104 | SHIP_TYPE_ID_2SW | Character(1) | VARCHAR2(1) NOT NULL | Ship Type Id |
| 105 | BILL_OF_LADING_1SW | Character(1) | VARCHAR2(1) NOT NULL | Bill Of Lading |
| 106 | BILL_OF_LADING_2SW | Character(1) | VARCHAR2(1) NOT NULL | Bill Of Lading |
| 107 | SOLD_TO_CUSTID_1SW | Character(1) | VARCHAR2(1) NOT NULL | Sold To |
| 108 | SOLD_TO_CUSTID_2SW | Character(1) | VARCHAR2(1) NOT NULL | Sold To |
| 109 | SOLDTO_ADDRNUM_1SW | Character(1) | VARCHAR2(1) NOT NULL | Sold To Addr Num |
| 110 | SOLDTO_ADDRNUM_2SW | Character(1) | VARCHAR2(1) NOT NULL | Sold To Addr Num |
| 111 | SHIP_TO_CUSTID_1SW | Character(1) | VARCHAR2(1) NOT NULL | Ship To |
| 112 | SHIP_TO_CUSTID_2SW | Character(1) | VARCHAR2(1) NOT NULL | Ship To |
| 113 | SHIPTO_ADDRNUM_1SW | Character(1) | VARCHAR2(1) NOT NULL | Ship To Loc |
| 114 | SHIPTO_ADDRNUM_2SW | Character(1) | VARCHAR2(1) NOT NULL | Ship To Loc |
| 115 | ORDER_DATE_1SW | Character(1) | VARCHAR2(1) NOT NULL | Order Date |
| 116 | ORDER_DATE_2SW | Character(1) | VARCHAR2(1) NOT NULL | Order Date |
| 117 | PACKSLIP_NO_1SW | Character(1) | VARCHAR2(1) NOT NULL | Pack Slip Number |
| 118 | PACKSLIP_NO_2SW | Character(1) | VARCHAR2(1) NOT NULL | Pack Slip Number |
| 119 | BU_CA_1SW | Character(1) | VARCHAR2(1) NOT NULL | Contract Business Unit |
| 120 | BU_CA_2SW | Character(1) | VARCHAR2(1) NOT NULL | Contract Business Unit |
| 121 | CONTRACT_NUM_1SW | Character(1) | VARCHAR2(1) NOT NULL | Contract Number |
| 122 | CONTRACT_NUM_2SW | Character(1) | VARCHAR2(1) NOT NULL | Contract Number |
| 123 | CNTRCT_LN_NUM_1SW | Character(1) | VARCHAR2(1) NOT NULL | Contract Line |
| 124 | CNTRCT_LN_NUM_2SW | Character(1) | VARCHAR2(1) NOT NULL | Contract Line |
| 125 | CONTRACT_DT_1SW | Character(1) | VARCHAR2(1) NOT NULL | Contract Date |
| 126 | CONTRACT_DT_2SW | Character(1) | VARCHAR2(1) NOT NULL | Contract Date |
| 127 | CONTRACT_TYPE_1SW | Character(1) | VARCHAR2(1) NOT NULL | Contract Type |
| 128 | CONTRACT_TYPE_2SW | Character(1) | VARCHAR2(1) NOT NULL | Contract Type |
| 129 | PC_FIELDS_HYP_1SW | Character(1) | VARCHAR2(1) NOT NULL | Projects Fields Hyperlink |
| 130 | PC_FIELDS_HYP_2SW | Character(1) | VARCHAR2(1) NOT NULL | Projects Fields Hyperlink |
| 131 | EMPLID_1SW | Character(1) | VARCHAR2(1) NOT NULL | Empl ID |
| 132 | EMPLID_2SW | Character(1) | VARCHAR2(1) NOT NULL | Empl ID |
| 133 | RESOURCE_ID_1SW | Character(1) | VARCHAR2(1) NOT NULL | Resource Id |
| 134 | RESOURCE_ID_2SW | Character(1) | VARCHAR2(1) NOT NULL | Resource Id |
| 135 | BILL_PLAN_ID_1SW | Character(1) | VARCHAR2(1) NOT NULL | Billing Plan ID |
| 136 | BILL_PLAN_ID_2SW | Character(1) | VARCHAR2(1) NOT NULL | Billing Plan ID |
| 137 | BPLAN_LN_NBR_1SW | Character(1) | VARCHAR2(1) NOT NULL | BP Line |
| 138 | BPLAN_LN_NBR_2SW | Character(1) | VARCHAR2(1) NOT NULL | BP Line |
| 139 | EVENT_OCCUR_1SW | Character(1) | VARCHAR2(1) NOT NULL | Occurrence |
| 140 | EVENT_OCCUR_2SW | Character(1) | VARCHAR2(1) NOT NULL | Occurrence |
| 141 | CA_PPD_SEQ_1SW | Character(1) | VARCHAR2(1) NOT NULL | PPD Add Seq |
| 142 | CA_PPD_SEQ_2SW | Character(1) | VARCHAR2(1) NOT NULL | PPD Add Seq |
| 143 | PROJ_LN_HYP_1SW | Character(1) | VARCHAR2(1) NOT NULL | Project Info |
| 144 | PROJ_LN_HYP_2SW | Character(1) | VARCHAR2(1) NOT NULL | Project Info |
| 145 | START_DT_1SW | Character(1) | VARCHAR2(1) NOT NULL | Start Date |
| 146 | START_DT_2SW | Character(1) | VARCHAR2(1) NOT NULL | Start Date |
| 147 | END_DT_1SW | Character(1) | VARCHAR2(1) NOT NULL | End Date |
| 148 | END_DT_2SW | Character(1) | VARCHAR2(1) NOT NULL | End Date |
| 149 | ACTIVITY_TYPE_1SW | Character(1) | VARCHAR2(1) NOT NULL | Activity Type |
| 150 | ACTIVITY_TYPE_2SW | Character(1) | VARCHAR2(1) NOT NULL | Activity Type |
| 151 | ANALYSIS_TYPE_1SW | Character(1) | VARCHAR2(1) NOT NULL | Analysis Type |
| 152 | ANALYSIS_TYPE_2SW | Character(1) | VARCHAR2(1) NOT NULL | Analysis Type |
| 153 | SERVICE_CUSTID_1SW | Character(1) | VARCHAR2(1) NOT NULL | Service Cust |
| 154 | SERVICE_CUSTID_2SW | Character(1) | VARCHAR2(1) NOT NULL | Service Cust |
| 155 | SERVICE_LOC_1SW | Character(1) | VARCHAR2(1) NOT NULL | Service Loc |
| 156 | SERVICE_LOC_2SW | Character(1) | VARCHAR2(1) NOT NULL | Service Loc |
| 157 | USER1_1SW | Character(1) | VARCHAR2(1) NOT NULL | User 1 |
| 158 | USER1_2SW | Character(1) | VARCHAR2(1) NOT NULL | User 1 |
| 159 | USER2_1SW | Character(1) | VARCHAR2(1) NOT NULL | User 2 |
| 160 | USER2_2SW | Character(1) | VARCHAR2(1) NOT NULL | User 2 |
| 161 | USER_AMT1_1SW | Character(1) | VARCHAR2(1) NOT NULL | User Amt 1 |
| 162 | USER_AMT1_2SW | Character(1) | VARCHAR2(1) NOT NULL | User Amt 1 |
| 163 | USER_DT1_1SW | Character(1) | VARCHAR2(1) NOT NULL | User Date 1 |
| 164 | USER_DT1_2SW | Character(1) | VARCHAR2(1) NOT NULL | User Date 1 |
| 165 | CUST_PO_PB_1SW | Character(1) | VARCHAR2(1) NOT NULL | Cust PO Hyperlink |
| 166 | CUST_PO_PB_2SW | Character(1) | VARCHAR2(1) NOT NULL | Cust PO Hyperlink |