VCHR_ACCT_DRILL

(SQL View)
 Index Back

AP Accounting Entries


SELECT A.BUSINESS_UNIT_GL , A.JOURNAL_ID , A.JOURNAL_DATE , A.JOURNAL_LINE , A.BUSINESS_UNIT , A.VOUCHER_ID , A.UNPOST_SEQ , A.APPL_JRNL_ID , A.PYMNT_CNT , A.VOUCHER_LINE_NUM , A.DISTRIB_LINE_NUM , A.DST_ACCT_TYPE , A.CF_BAL_LINE_NUM , A.LEDGER , A.ACCOUNT , A.DEPTID , A.STATISTICS_CODE , A.FOREIGN_AMOUNT , A.FOREIGN_CURRENCY , A.RT_TYPE , A.RATE_MULT , A.RATE_DIV , A.MONETARY_AMOUNT , A.QTY_VCHR , A.STATISTIC_AMOUNT , A.JRNL_LN_REF , A.DESCR , A.MERCHANDISE_AMT , A.MERCH_AMT_BSE , A.DSCNT_AMT_BSE , A.SALETX_AMT_BSE , A.USETAX_AMT_BSE , A.VAT_INV_AMT_BSE , A.VAT_NONINV_AMT_BSE , A.VAT_RCVRY_AMT_BSE , A.FREIGHT_AMT_BSE , A.CHART_EDIT_STATUS , A.ACCOUNTING_DT , A.ACCOUNTING_PERIOD , A.FISCAL_YEAR , A.MOVEMENT_FLAG , A.GL_DISTRIB_STATUS , A.PROCESS_INSTANCE , A.ERROR_FLAG , A.FINAL_REF_IND , A.REFERENCE_NUMBER , A.REF_CLOSED , A.REF_DIST_LINE , A.REF_LINE_NUMBER , A.BUSINESS_UNIT_PO , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , A.PO_DIST_LINE_NUM , A.BCM_LINE_STATUS , A.BCM_POST_AMOUNT , A.BCM_POST_AMT_TOT , A.BUSINESS_UNIT_PC , A.ACTIVITY_ID , A.ANALYSIS_TYPE , A.RESOURCE_TYPE , A.RESOURCE_CATEGORY , A.RESOURCE_SUB_CAT , A.PC_DISTRIB_STATUS , A.CURRENCY_CD , A.ASSET_FLG , A.BUSINESS_UNIT_AM , A.ASSET_ID , A.PROFILE_ID , A.AM_DISTRIB_STATUS , A.VAT_DISTRIB_STATUS , A.BUSINESS_UNIT_RECV , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.RECV_DIST_LINE_NUM , A.LEDGER_GROUP , A.VAT_TXN_TYPE_CD , A.FREIGHT_AMT , A.SALETX_AMT , A.USETAX_AMT , A.VAT_INV_AMT , A.VAT_NONINV_AMT , A.DSCNT_AMT , A.VAT_RECOVERY_PCT , A.VAT_BASIS_AMT , A.VAT_BASIS_AMT_BSE , A.VAT_CALC_AMT , A.VAT_CALC_AMT_BSE , A.VAT_RCVRY_AMT , A.VAT_DSCNT_ADJ , A.VAT_DSCNT_ADJ_BSE , A.VAT_DSCNT_RCVRY , A.VAT_DSCNT_RCVR_BSE , A.TAX_CD_VAT , A.TAX_CD_VAT_PCT , A.VAT_DCLRTN_DT , %subrec(CF16_AN_SBR,A ) , A.PROJECT_ID , A.VAT_APPLICABILITY , A.VAT_REBATE_PCT , A.VAT_REBATE_AMT , A.VAT_REBATE_AMT_BSE , A.VAT_USE_ID , A.VAT_ENTITY , A.PHYSICAL_NATURE , A.COUNTRY_VAT_SUPPLY , A.VAT_SVC_SUPPLY_FLG , A.VAT_SERVICE_TYPE , A.COUNTRY_VAT_PERFRM , A.STATE_VAT_DEFAULT , A.VAT_TREATMENT , A.SHIPTO_ID , A.SUT_BASE_ID , A.TAX_CD_SUT , A.TAX_CD_SUT_PCT , A.SUT_APPLICABILITY , A.DOC_TYPE , A.DOC_SEQ_DATE , A.DOC_SEQ_NBR , A.DOC_SEQ_STATUS , A.POSTING_DATE , A.IST_DISTRIB_STATUS , A.OPEN_ITEM_KEY FROM PS_VCHR_ACCTG_LINE A ORDER BY A.BUSINESS_UNIT , A.VOUCHER_ID ASC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
2 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.
3 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
4 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.
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BUS_AP_NONVW

6 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
7 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".
8 APPL_JRNL_ID Character(10) VARCHAR2(10) NOT NULL Journal Template
9 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
10 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
11 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
12 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
13 CF_BAL_LINE_NUM Number(10,0) DECIMAL(10) NOT NULL Chart Field Balancing Line Num
14 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
15 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account

Prompt Table: GL_ACCT_BUGL_VW

16 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

Prompt Table: DEPTID_BUGL_VW

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 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
38 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
39 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.
40 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
41 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
42 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
43 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
44 ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag

Y/N Table Edit

Default Value: N

45 FINAL_REF_IND Character(1) VARCHAR2(1) NOT NULL Final Reference Indicator

Y/N Table Edit

Default Value: N

46 REFERENCE_NUMBER Character(10) VARCHAR2(10) NOT NULL Reference Number
47 REF_CLOSED Character(1) VARCHAR2(1) NOT NULL Reference Closed

Y/N Table Edit

48 REF_DIST_LINE Number(5,0) INTEGER NOT NULL Ref Dist Line
49 REF_LINE_NUMBER Number(5,0) INTEGER NOT NULL Reference Line Number
50 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
51 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
52 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
53 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
54 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
55 BCM_LINE_STATUS Character(2) VARCHAR2(2) NOT NULL Budget Checking Line Status

Default Value: N

56 BCM_POST_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL BCM Post Amount
57 BCM_POST_AMT_TOT Signed Number(28,3) DECIMAL(26,3) NOT NULL BCM Total Post Amount
58 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
59 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
60 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
61 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
62 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
63 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
64 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
65 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
66 ASSET_FLG Character(1) VARCHAR2(1) NOT NULL Assets Applicable
67 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
68 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
69 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
70 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
71 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
72 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
73 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
74 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
75 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
76 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line
77 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
78 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.
79 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
80 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
81 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
82 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount
83 VAT_NONINV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non-Invoice Amount
84 DSCNT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Discount Amount
85 VAT_RECOVERY_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Recovery Percent
86 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.
87 VAT_BASIS_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Basis Amt in Base Curr
88 VAT_CALC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount
89 VAT_CALC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Calculated Amount Base Cur
90 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt
91 VAT_DSCNT_ADJ Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Dscnt Adj
92 VAT_DSCNT_ADJ_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Discount Adjust Base Curr
93 VAT_DSCNT_RCVRY Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Dscnt Adj Rcvr
94 VAT_DSCNT_RCVR_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Discnt Recovery Base Curr
95 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.
96 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.
97 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"". "
98 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: OPERUNT_BUGL_VW

99 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product ChartField

Prompt Table: PRODUCT_BUGL_VW

100 FUND_CODE Character(5) VARCHAR2(5) NOT NULL Fund Code

Prompt Table: FUND_BUGL_VW

101 CLASS_FLD Character(5) VARCHAR2(5) NOT NULL Class Field

Prompt Table: CLASSCF_BUGL_VW

102 PROGRAM_CODE Character(5) VARCHAR2(5) NOT NULL Program Code ChartField

Prompt Table: PROGRAM_BUGL_VW

103 BUDGET_REF Character(8) VARCHAR2(8) NOT NULL Budget Reference

Prompt Table: BUD_REF_BUGL_VW

104 AFFILIATE Character(5) VARCHAR2(5) NOT NULL Affiliate

Prompt Table: AFFILIATE_VW

105 AFFILIATE_INTRA1 Character(10) VARCHAR2(10) NOT NULL IntraUnit Affiliate1

Prompt Table: %EDIT_INTRA01

106 AFFILIATE_INTRA2 Character(10) VARCHAR2(10) NOT NULL Operating Unit Affiliate

Prompt Table: %EDIT_INTRA02

107 CHARTFIELD1 Character(10) VARCHAR2(10) NOT NULL Expansion chartfield 1

Prompt Table: CF1_BUGL_VW

108 CHARTFIELD2 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 2

Prompt Table: CF2_BUGL_VW

109 CHARTFIELD3 Character(10) VARCHAR2(10) NOT NULL Expansion Chartfield 3

Prompt Table: CF3_BUGL_VW

110 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
111 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
112 VAT_REBATE_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL VAT Rebate Percent
113 VAT_REBATE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt
114 VAT_REBATE_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Rebate Amt in Base Curr
115 VAT_USE_ID Character(6) VARCHAR2(6) NOT NULL VAT Use Type
116 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.
117 PHYSICAL_NATURE Character(1) VARCHAR2(1) NOT NULL Physical Nature
G=Goods
S=Services
118 COUNTRY_VAT_SUPPLY Character(3) VARCHAR2(3) NOT NULL VAT Place of Supply Country
119 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
120 VAT_SERVICE_TYPE Character(1) VARCHAR2(1) NOT NULL VAT Service Type
1=Freight Transport
2=Other
3=Electronics/Communication
121 COUNTRY_VAT_PERFRM Character(3) VARCHAR2(3) NOT NULL Country Where Service Physically Performed
122 STATE_VAT_DEFAULT Character(6) VARCHAR2(6) NOT NULL VAT Defaulting State
123 VAT_TREATMENT Character(4) VARCHAR2(4) NOT NULL VAT Treatment
124 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
125 SUT_BASE_ID Character(10) VARCHAR2(10) NOT NULL Sales/Use Tax Destination
126 TAX_CD_SUT Character(8) VARCHAR2(8) NOT NULL Tax Code - Sales and Use Tax
127 TAX_CD_SUT_PCT Number(8,4) DECIMAL(7,4) NOT NULL Sales/Use Tax Code Percent
128 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
129 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.
130 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.
131 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.
132 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
133 POSTING_DATE Date(10) DATE Posting Date
134 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
135 OPEN_ITEM_KEY Character(30) VARCHAR2(30) NOT NULL Open Item Key