VCHRACCLN_TAO(SQL Table) |
Index Back |
|---|---|
AP Accounting Entries |
| # | 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 | VOUCHER_ID | Character(8) | VARCHAR2(8) NOT NULL | Voucher ID |
| 4 | UNPOST_SEQ | Number(2,0) | SMALLINT NOT NULL | Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1". |
| 5 | APPL_JRNL_ID | Character(10) | VARCHAR2(10) NOT NULL | Journal Template |
| 6 | POSTING_PROCESS | Character(4) | VARCHAR2(4) NOT NULL |
Posting Process
ACAV=Period End Accruals ACCR=AP Accrual CANC=Payment Cancelations CASH=Cash Clearing CLOS=Voucher Closure DFTA=Draft Accrual PCAD=Card PPAY=Prepaid Reversals PREP=Prepaids PYMN=Payments RACC=Receipt Accrual RCVL=Revaluation REVL=Revaluations VOID=Void WTHA=Withholding Accrual |
| 7 | PYMNT_CNT | Number(5,0) | INTEGER NOT NULL | Payments |
| 8 | VOUCHER_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Voucher Line Number |
| 9 | DISTRIB_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Distribution Line |
| 10 | 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 |
| 11 | CF_BAL_LINE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Chart Field Balancing Line Num |
| 12 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 13 | TAX_AUTHORITY_CD | Character(3) | VARCHAR2(3) NOT NULL | Tax Authority |
| 14 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table: GL_ACCT_BUGL_VW |
| 15 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 16 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 17 | STATISTICS_CODE | Character(3) | VARCHAR2(3) NOT NULL | Statistics Code |
| 18 | FOREIGN_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item. |
| 19 | FOREIGN_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Foreign Currency Code |
| 20 | 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. |
| 21 | RATE_MULT | Signed Number(17,8) | DECIMAL(15,8) NOT NULL | Rate Multiplier |
| 22 | RATE_DIV | Number(16,8) | DECIMAL(15,8) NOT NULL | Rate Divisor |
| 23 | MONETARY_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account. |
| 24 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 25 | STATISTIC_AMOUNT | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Specifies the amount associated with a statistical account on a journal line or a distribution line. It represents a quantity rather than a monetary amount and is qualified by the Unit of Measure associated with the STATISTICS_CODE or statistics ACCOUNT. |
| 26 | JRNL_LN_REF | Character(10) | VARCHAR2(10) NOT NULL | Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal line. It can be manually entered, or be defaulted from an accounting entry definition or from a Journal Generator Template. The journal line reference is optional, but helpful if you need to trace back to the source of the transaction. |
| 27 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 28 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |
| 29 | MERCH_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Merchandise Amount |
| 30 | DSCNT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Discount Amount |
| 31 | SALETX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Sales Tax Amount |
| 32 | USETAX_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Use Tax Amount |
| 33 | VAT_INV_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amt Base Curr |
| 34 | VAT_NONINV_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Non-Invoice Amt Base Curr |
| 35 | VAT_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt in Base Curr |
| 36 | FREIGHT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Freight Amount |
| 37 | CSD_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty NonRecovery Amount |
| 38 | CSD_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Recovery Amount |
| 39 | EXD_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Non Recovery |
| 40 | EXD_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Recovery Amount |
| 41 | MISC_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Misc. Amount |
| 42 | STX_NRCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tx Amt NonRecovery in Bse Curr |
| 43 | STX_RCVRY_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Recovery Amt in Base Curr |
| 44 | CHART_EDIT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Chart Edit Status
K=Errors - Cannot be saved O=ChartFields Valid R=Errors - Not Postable S=Errors - Suspense Entries |
| 45 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 46 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
| 47 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 48 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BUPRCR_NONVW |
| 49 | JOURNAL_ID | Character(10) | VARCHAR2(10) NOT NULL | Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier. |
| 50 | JOURNAL_DATE | Date(10) | DATE | Specifies the date the journal was created. |
| 51 | JOURNAL_LINE | Number(9,0) | DECIMAL(9) NOT NULL | Uniquely identifies a journal line with a sequence number. Within a single journal entry, the line sequence begins with 1 and automatically increments by 1 for each succeeding journal line. There can be any number of lines associated with a journal header. |
| 52 | MOVEMENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A flag associated with a journal line that indicates whether its amount is in the natural sign or the reversal sign.
N=Natural R=Reversal |
| 53 | GL_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts D=Distributed G=Generated H=Hold I=Ignored J=Creating Journals M=Modified N=None P=To be processed X=Waiting for Reversal |
| 54 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 55 | ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Error Flag
Y/N Table Edit Default Value: N |
| 56 | FINAL_REF_IND | Character(1) | VARCHAR2(1) NOT NULL |
Final Reference Indicator
Y/N Table Edit Default Value: N |
| 57 | REFERENCE_NUMBER | Character(10) | VARCHAR2(10) NOT NULL | Reference Number |
| 58 | REF_CLOSED | Character(1) | VARCHAR2(1) NOT NULL |
Reference Closed
Y/N Table Edit |
| 59 | REF_DIST_LINE | Number(5,0) | INTEGER NOT NULL | Ref Dist Line |
| 60 | REF_LINE_NUMBER | Number(5,0) | INTEGER NOT NULL | Reference Line Number |
| 61 | BUSINESS_UNIT_PO | Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 62 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 63 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 64 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 65 | PO_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | PO Distribution Line Number |
| 66 | BCM_LINE_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Budget Checking Line Status
Default Value: N |
| 67 | BCM_POST_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | BCM Post Amount |
| 68 | BCM_POST_AMT_TOT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | BCM Total Post Amount |
| 69 | BUSINESS_UNIT_PC | Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 70 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 71 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 72 | RESOURCE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Source Type |
| 73 | RESOURCE_CATEGORY | Character(5) | VARCHAR2(5) NOT NULL | Category |
| 74 | RESOURCE_SUB_CAT | Character(5) | VARCHAR2(5) NOT NULL | Subcategory |
| 75 | PC_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
PC Distribution Status
B=Budget Check D=Distributed G=Generated H=Hold I=Ignore M=Modified N=Not Distributed S=Staged |
| 76 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 77 | ASSET_FLG | Character(1) | VARCHAR2(1) NOT NULL | Assets Applicable |
| 78 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 79 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 80 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 81 | COST_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Cost Type |
| 82 | AM_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
AM Distribution Status
D=Distributed I=Ignore M=Modified N=Not Distributed P=Pending V=Reversed |
| 83 | VAT_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
VAT Distribution Status
D=Distributed E=Error Flag I=Ignored M=Archival Entry N=Not Distributed P=Processed R=Reversal Entry U=Undefined |
| 84 | BUSINESS_UNIT_RECV | Character(5) | VARCHAR2(5) NOT NULL | Receiving Business Unit |
| 85 | RECEIVER_ID | Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 86 | RECV_LN_NBR | Number(5,0) | INTEGER NOT NULL | Receipt Line |
| 87 | RECV_SHIP_SEQ_NBR | Number(3,0) | SMALLINT NOT NULL | Receiver Shipping Sequence |
| 88 | RECV_DIST_LINE_NUM | Number(5,0) | INTEGER NOT NULL | Receiver Distrib Line |
| 89 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 90 | VAT_TXN_TYPE_CD | Character(4) | VARCHAR2(4) NOT NULL | Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales. |
| 91 | FREIGHT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 92 | SALETX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 93 | USETAX_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 94 | CSD_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty NonRecovery Amount |
| 95 | CSD_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Custom Duty Recovery Amount |
| 96 | EXD_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise NonRcvry Amount |
| 97 | EXD_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Excise Recovery Amount |
| 98 | MISC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 99 | STX_NRCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Nonrecovery |
| 100 | STX_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tax Recovery Amount |
| 101 | FREIGHT_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Freight Amount |
| 102 | FREIGHT_AMT_NP_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Freight Amount |
| 103 | MISC_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Misc. Amount |
| 104 | MISC_AMT_NP_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Misc. Amount |
| 105 | SALETX_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Sales Tax Amount |
| 106 | SALETX_AMT_NP_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Sales Tax Amount |
| 107 | USETAX_AMT_NP | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Use Tax Amount |
| 108 | USETAX_AMT_NP_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Base Use Tax Amount |
| 109 | VAT_INV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Invoice Amount |
| 110 | VAT_NONINV_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Non-Invoice Amount |
| 111 | DSCNT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Discount Amount |
| 112 | VAT_RECOVERY_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Recovery Percent |
| 113 | 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. |
| 114 | VAT_BASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Basis Amt in Base Curr |
| 115 | VAT_CALC_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Calculated Amount |
| 116 | VAT_CALC_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Calculated Amount Base Cur |
| 117 | VAT_RCVRY_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Recovery Amt |
| 118 | VAT_DSCNT_ADJ | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Dscnt Adj |
| 119 | VAT_DSCNT_ADJ_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Discount Adjust Base Curr |
| 120 | VAT_DSCNT_RCVRY | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Dscnt Adj Rcvr |
| 121 | VAT_DSCNT_RCVR_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Discnt Recovery Base Curr |
| 122 | TAX_CD_VAT | Character(8) | VARCHAR2(8) NOT NULL | Defines the VAT (Value Added Tax) percentage (via link to the Tax Authority) and is used to retrieve VAT accounting ChartFields. The VAT code determines how the VAT amount is calculated on a transaction and how that amount is accounted and reported for. |
| 123 | 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. |
| 124 | VAT_DCLRTN_DT | Date(10) | DATE | "Specifies the date of the invoice when the VAT declaration point (VAT_DCLRTN_POINT) is ""Invoice"". The VAT declaration date is automatically set to the invoice date by the system. This field does not apply when the declaration point is ""payment"". " |
| 125 | OPERATING_UNIT | Character(8) | VARCHAR2(8) NOT NULL |
Operating Unit ChartField
Prompt Table: OPERUNT_BUGL_VW |
| 126 | PRODUCT | Character(6) | VARCHAR2(6) NOT NULL |
Product ChartField
Prompt Table: PRODUCT_BUGL_VW |
| 127 | FUND_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table: FUND_BUGL_VW |
| 128 | CLASS_FLD | Character(5) | VARCHAR2(5) NOT NULL |
Class Field
Prompt Table: CLASSCF_BUGL_VW |
| 129 | PROGRAM_CODE | Character(5) | VARCHAR2(5) NOT NULL |
Program Code ChartField
Prompt Table: PROGRAM_BUGL_VW |
| 130 | BUDGET_REF | Character(8) | VARCHAR2(8) NOT NULL |
Budget Reference
Prompt Table: BUD_REF_BUGL_VW |
| 131 | AFFILIATE | Character(5) | VARCHAR2(5) NOT NULL |
Affiliate
Prompt Table: AFFILIATE_VW |
| 132 | AFFILIATE_INTRA1 | Character(10) | VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table: %EDIT_INTRA01 |
| 133 | AFFILIATE_INTRA2 | Character(10) | VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table: %EDIT_INTRA02 |
| 134 | CHARTFIELD1 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion chartfield 1
Prompt Table: CF1_BUGL_VW |
| 135 | CHARTFIELD2 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table: CF2_BUGL_VW |
| 136 | CHARTFIELD3 | Character(10) | VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table: CF3_BUGL_VW |
| 137 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJID_BUGL_VW |
| 138 | VAT_APPLICABILITY | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates whether or not a transaction is eligible for VAT (Value Added Tax) taxation or why it is not eligible.
E=Exempt N=Not Applicable O=Outside of Scope of VAT S=Suspended T=Taxable V=VAT Only X=Exonerated |
| 139 | VAT_REBATE_PCT | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | VAT Rebate Percent |
| 140 | VAT_REBATE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Rebate Amt |
| 141 | VAT_REBATE_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Rebate Amt in Base Curr |
| 142 | VAT_USE_ID | Character(6) | VARCHAR2(6) NOT NULL | VAT Use Type |
| 143 | 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. |
| 144 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL | Ship To Location |
| 145 | SUT_BASE_ID | Character(10) | VARCHAR2(10) NOT NULL | Sales/Use Tax Destination |
| 146 | TAX_CD_SUT | Character(8) | VARCHAR2(8) NOT NULL | Tax Code - Sales and Use Tax |
| 147 | TAX_CD_SUT_PCT | Number(8,4) | DECIMAL(7,4) NOT NULL | Sales/Use Tax Code Percent |
| 148 | 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 |
| 149 | DOC_TYPE | Character(8) | VARCHAR2(8) NOT NULL | Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code. |
| 150 | DOC_SEQ_DATE | Date(10) | DATE | Specifies the date that a document sequence number is assigned to a document or the date the document was created. |
| 151 | DOC_SEQ_NBR | Character(12) | VARCHAR2(12) NOT NULL | Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated. |
| 152 | DOC_SEQ_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status |
| 153 | POSTING_DATE | Date(10) | DATE | Posting Date |
| 154 | IST_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Intrastat Distribution Status
A=Awaiting Arrival Processing D=Distributed I=Ignored M=Archival Entry N=Not Distributed R=Reversal Entry S=Awaiting Dispatch Processing U=Undefined |
| 155 | PRIMARY_LEDGER | Character(1) | VARCHAR2(1) NOT NULL | A flag that indicates whether or not (Y or N) a ledger is designated as the primary ledger in a ledger group. |
| 156 | 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 |
| 157 | BUDGET_LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
->
SL - 15-AUG-2002
MISC_CRITERIA label has been added
<-
B=Bypass E=Error N=Not Chk'd V=Valid W=Warning Default Value: V |
| 158 | CLOSE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Close Status Indicator
C=Closed O=Open Default Value: O |
| 159 | BUDGET_DT | Date(10) | DATE | Budget Date |
| 160 | KK_TRAN_OVER_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control source transaction override flag
N=No Y=Yes |
| 161 | KK_TRAN_OVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Commitment Control source transaction override operator |
| 162 | KK_TRAN_OVER_DTTM | DateTime(26) | TIMESTAMP | Commitment Control source transaction override datetime |
| 163 | VAT_TRANS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Represents the sale or purchase amount against which the VAT is applicable. |
| 164 | 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 |
| 165 | VAT_TRANS_AMT_RPTG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Transaction Amt Reporting |
| 166 | CURRENCY_RPTG | Character(3) | VARCHAR2(3) NOT NULL | Reporting Currency |
| 167 | VAT_INV_AMT_RPTG | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Amt in Reporting Currency |
| 168 | IU_ANCHOR_FLG | Character(1) | VARCHAR2(1) NOT NULL | Y/N flag used to specify which transaction line is the Inter/IntraUnit anchor flag (the line that contains the anchor Business Unit and ChartFields). |
| 169 | IU_SYS_TRAN_CD | Character(8) | VARCHAR2(8) NOT NULL | System Transactions are delivered system data, representing the activities that can require interunit or intraunit accounting entries. |
| 170 | IU_TRAN_CD | Character(8) | VARCHAR2(8) NOT NULL | Transaction Codes are user-defined. They are mapped to the delivered System Transactions. InterUnit and IntraUnit Templates are keyed by Transaction code, allowing users to vary their accounting by transaction. |
| 171 | ENTRY_EVENT | Character(10) | VARCHAR2(10) NOT NULL | Entry Event |
| 172 | EE_PROC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Entry Event Line Status
Default Value: N |
| 173 | VAT_LN_ENT_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Line Entered Amount |
| 174 | VAT_LN_ENT_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Line Entered Amt Base Curr |
| 175 | VAT_MBASIS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Memo Basis Amount |
| 176 | VAT_MBASIS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Memo Basis Amt Base Curr |
| 177 | VAT_MTRANS_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Memo Transaction Amount |
| 178 | VAT_MTRANS_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | VAT Memo Trans Amt Base Curr |
| 179 | EO_FROM_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 180 | OPEN_ITEM_KEY | Character(30) | VARCHAR2(30) NOT NULL | Open Item Key |
| 181 | PHYSICAL_NATURE | Character(1) | VARCHAR2(1) NOT NULL |
Physical Nature
G=Goods S=Services |
| 182 | COUNTRY_VAT_SUPPLY | Character(3) | VARCHAR2(3) NOT NULL | VAT Place of Supply Country |
| 183 | VAT_SVC_SUPPLY_FLG | Character(1) | VARCHAR2(1) NOT NULL |
VAT Services Place of Supply Flag
1=Supplier's Countries 2=Buyer's Countries 3=Where Physically Performed |
| 184 | VAT_SERVICE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
VAT Service Type
1=Freight Transport 2=Other 3=Electronics/Communication |
| 185 | COUNTRY_VAT_PERFRM | Character(3) | VARCHAR2(3) NOT NULL | Country Where Service Physically Performed |
| 186 | STATE_VAT_DEFAULT | Character(6) | VARCHAR2(6) NOT NULL | VAT Defaulting State |
| 187 | VAT_TREATMENT | Character(4) | VARCHAR2(4) NOT NULL | VAT Treatment |