BI_LNE_ADJ_TEO1(SQL Table) |
Index Back |
|---|---|
CCU TEO temp tableCCU temporary table for BI_LINE_ADJ_AUX |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EO_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Invoice |
| 4 | ADJ_AUX_LINE_SEQ | Number(5,0) | INTEGER NOT NULL | Line Seq Num |
| 5 | BI_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Billing Currency Code
Default Value: BI_HDR.BI_CURRENCY_CD |
| 6 | 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. "
Default Value: BI_HDR.BASE_CURRENCY |
| 7 | CURRENCY_CD_XEU | Character(3) | VARCHAR2(3) NOT NULL |
Euro Currency
Default Value: BI_HDR.CURRENCY_CD_XEU |
| 8 | INVOICE_LINE | Number(5,0) | INTEGER NOT NULL | Invoice Line |
| 9 | ORIGINAL_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Original Invoice |
| 10 | ORIGINAL_LINE_SEQ | Number(5,0) | INTEGER NOT NULL | Original Line Sequence 5 |
| 11 | NEXT_ADJ_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Adjusting Invoice |
| 12 | NEXT_ADJ_LINE_SEQ | Number(5,0) | INTEGER NOT NULL | Next Adjustment Line Sequence |
| 13 | PRIOR_ADJ_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Adjusted Invoice |
| 14 | PRIOR_ADJ_LINE_SEQ | Number(5,0) | INTEGER NOT NULL | Prior Adjustment Line Seq |
| 15 | LATEST_INVOICE | Character(22) | VARCHAR2(22) NOT NULL | Latest Invoice |
| 16 | LATEST_LINE_SEQ | Number(5,0) | INTEGER NOT NULL | Latest Line Sequence |
| 17 | LINE_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Line Type 1
ADV=Advance Billing BAE=Billed Amount in Excess BRT=Billing Retainage DAPP=Cust Deposit Applied DEP=Customer Deposit DISC=Discount Line DREF=Cust Deposit Refunded DRFF=Cust Deposit Refund Fee FRGT=Freight (Surcharge) MISC=Miscellaneous Charge PYCV=Payment with Corporate Voucher RAE=Reclaimed Amount in Excess REV=Revenue Line RSTK=Restock (Surcharge) SUR=Surcharge Line UTL=Utilization Line |
| 18 | IDENTIFIER | Character(18) | VARCHAR2(18) NOT NULL |
Identifier
Prompt Table: %EDITTABLE4 |
| 19 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 20 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL |
| 21 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
| 22 | CHARGE_FROM_DT | Date(10) | DATE | From Date for line charges |
| 23 | CHARGE_TO_DT | Date(10) | DATE | Through date for charges |
| 24 | UNIT_AMT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Unit Price |
| 25 | TAX_CD | Character(8) | VARCHAR2(8) NOT NULL |
Tax Code
Prompt Table: TAX_HEADER_TBL |
| 26 | TAX_EXEMPT_CERT | Character(30) | VARCHAR2(30) NOT NULL |
Exemption Certificate
Prompt Table: CUST_EXEMPT |
| 27 | TAX_EXEMPT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Tax Exempt Flag
Y/N Table Edit |
| 28 | NET_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amt |
| 29 | GROSS_EXTENDED_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Extended |
| 30 | NET_EXTENDED_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amount |
| 31 | GROSS_EXTENDED_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Extended |
| 32 | NET_EXTENDED_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Net Extended Amount |
| 33 | GROSS_EXTENDED_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Gross Extended |
| 34 | TOT_DISCOUNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amt |
| 35 | TOT_SURCHARGE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Surcharge Amt |
| 36 | TOT_DISCOUNT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Discount Amount |
| 37 | TOT_SURCHARGE_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Surcharge Amount |
| 38 | TOT_DISCOUNT_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Discount Amount |
| 39 | TOT_SURCHARGE_XEU | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Surcharge Amount |
| 40 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |
| 41 | CONTRACT_NUM | Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 42 | ADD_DTTM | DateTime(26) | TIMESTAMP | Date Time Added |
| 43 | LAST_UPDATE_DTTM | 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. |
| 44 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |
| 45 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |