AM_INTFC_TXN_VW

(SQL View)
 Index Back

AM Interface

AM Interface for Financial and Physical Data.

SELECT PA.INTFC_ID , PA.PROCESS_INSTANCE , PA.INTFC_LINE_NUM , PA.MC_DEFN_ID , PA.PI_ID , PA.BUSINESS_UNIT , PA.ASSET_ID , ' ' , PA.DTTM_STAMP , PA.INTFC_TYPE , PA.MC_DEFN_ID , 'A' , PA.INTFC_STATUS , PA.LOAD_STATUS , PA.APPROVAL_SW , PA.DESCR , PA.FINANCIAL_ASSET_SW , PA.LINEAR_ASSET_SW , PA.DESCRSHORT , PA.TAG_NUMBER , PA.PARENT_ID , PA.SERIAL_ID , PA.COMPONENT_OF_ID , PA.PROFILE_ID , PA.CAP_THRSHLD_ID , PA.DESCR_LONG , PA.ACQUISITION_DT , PA.IN_SERVICE_DT , %DateNull , %DateNull , %subrec(CF24A_AK_SBR, PA) , PA.DEPTID , PA.CATEGORY , PA.COST_TYPE , ' ' , 0 , %subrec(AM_CF1_N_SBR5, PA) , PA.QUANTITY , PA.TXN_CURRENCY_CD , 0 , 0 , PA.CURRENCY_CD , 0 , 0 , 0 , 0 , ' ' , 0 , PA.TXN_AMOUNT , PA.MERCHANDISE_AMT , PA.SALETX_AMT , PA.USETAX_AMT , PA.FREIGHT_AMT , PA.MISC_AMT , PA.VAT_INV_AMT , PA.VAT_NRCVR_AMT , PA.VAT_RCVRY_AMT , PA.AMOUNT , PA.MERCH_AMT_BSE , PA.SALETX_AMT_BSE , PA.USETAX_AMT_BSE , PA.FREIGHT_AMT_BSE , PA.MISC_AMT_BSE , PA.VAT_INV_AMT_BSE , PA.VAT_NRCVR_AMT_BSE , PA.VAT_RCVRY_AMT_BSE , PA.RATE_MULT , PA.RATE_DIV , %subrec(AM_FEEDSYS_SBR, PA) , 0 , PA.EMPLID , PA.CUSTODIAN , PA.CUSTODIAN_EFFDT , PA.EFFSEQ , PA.LOCATION , PA.LOCATION_EFFDT , PA.LOCATION_EFFSEQ , PA.AREA_ID , PA.SEQUENCE_NBR_6 , PA.MFG_ID , PA.MANUFACTURER , PA.MODEL , PA.PROD_VERSION , ' ' , PA.TRANS_IN_OUT , PA.CONSOLIDATION_ID , 0 , 0 FROM PS_INTFC_PHY_A PA WHERE NOT EXISTS ( SELECT 'X' FROM PS_INTFC_FIN F WHERE F.INTFC_ID = PA.INTFC_ID AND F.INTFC_LINE_NUM = PA.INTFC_LINE_NUM AND F.BUSINESS_UNIT = PA.BUSINESS_UNIT AND F.ASSET_ID = PA.ASSET_ID AND F.INTFC_TYPE = PA.INTFC_TYPE ) UNION ALL SELECT F.INTFC_ID ,F.PROCESS_INSTANCE , F.INTFC_LINE_NUM , F.MC_DEFN_ID , F.PI_ID , F.BUSINESS_UNIT , F.ASSET_ID , F.BOOK , F.DTTM_STAMP , F.INTFC_TYPE , F.MC_DEFN_ID , '2' , F.INTFC_STATUS , F.LOAD_STATUS , F.APPROVAL_SW , PA.DESCR , PA.FINANCIAL_ASSET_SW , PA.LINEAR_ASSET_SW , PA.DESCRSHORT , PA.TAG_NUMBER , PA.PARENT_ID , PA.SERIAL_ID , PA.COMPONENT_OF_ID , PA.PROFILE_ID , PA.CAP_THRSHLD_ID , PA.DESCR_LONG , PA.ACQUISITION_DT , F.IN_SERVICE_DT , F.TRANS_DT , F.ACCOUNTING_DT , %subrec(CF24A_AK_SBR, F) , F.DEPTID , F.CATEGORY , F.COST_TYPE , F.TRANS_CODE , F.CF_SEQNO , %subrec(AM_CF1_N_SBR5, F) , F.QUANTITY , F.TXN_CURRENCY_CD , F.TXN_COST , F.TXN_PROCEEDS , F.CURRENCY_CD , F.COST , F.SALVAGE_VALUE , F.DEPR , F.DEPR_YTD , F.TXN_CURRENCY_CD2 , F.TXN_REMOVAL_COST , PA.TXN_AMOUNT , PA.MERCHANDISE_AMT , PA.SALETX_AMT , PA.USETAX_AMT , PA.FREIGHT_AMT , PA.MISC_AMT , PA.VAT_INV_AMT , PA.VAT_NRCVR_AMT , PA.VAT_RCVRY_AMT , PA.AMOUNT , PA.MERCH_AMT_BSE , PA.SALETX_AMT_BSE , PA.USETAX_AMT_BSE , PA.FREIGHT_AMT_BSE , PA.MISC_AMT_BSE , PA.VAT_INV_AMT_BSE , PA.VAT_NRCVR_AMT_BSE , PA.VAT_RCVRY_AMT_BSE , F.RATE_MULT , F.RATE_DIV , %subrec(AM_FEEDSYS_SBR, PA) , F.DISTRIB_LINE_NUM , PA.EMPLID , PA.CUSTODIAN , PA.CUSTODIAN_EFFDT , PA.EFFSEQ , PA.LOCATION , PA.LOCATION_EFFDT , PA.LOCATION_EFFSEQ , PA.AREA_ID , PA.SEQUENCE_NBR_6 , PA.MFG_ID , PA.MANUFACTURER , PA.MODEL , PA.PROD_VERSION , F.TRANSFER_BU , F.TRANS_IN_OUT , PA.CONSOLIDATION_ID , F.MESSAGE_SET_NBR , F.MESSAGE_NBR FROM PS_INTFC_PHY_A PA , PS_INTFC_FIN F WHERE F.INTFC_ID = PA.INTFC_ID AND F.INTFC_LINE_NUM = PA.INTFC_LINE_NUM AND F.BUSINESS_UNIT = PA.BUSINESS_UNIT AND F.ASSET_ID = PA.ASSET_ID AND F.INTFC_TYPE = PA.INTFC_TYPE UNION ALL SELECT F.INTFC_ID ,F.PROCESS_INSTANCE , F.INTFC_LINE_NUM , F.MC_DEFN_ID , F.PI_ID , F.BUSINESS_UNIT , F.ASSET_ID , F.BOOK , F.DTTM_STAMP , F.INTFC_TYPE , F.MC_DEFN_ID , 'F' , F.INTFC_STATUS , F.LOAD_STATUS , F.APPROVAL_SW , A.DESCR , ' ' , A.LINEAR_ASSET_SW , A.DESCRSHORT , A.TAG_NUMBER , A.PARENT_ID , A.SERIAL_ID , A.COMPONENT_OF_ID , A.PROFILE_ID , A.CAP_THRSHLD_ID , A.DESCR_LONG , A.ACQUISITION_DT , F.IN_SERVICE_DT , F.TRANS_DT , F.ACCOUNTING_DT , %subrec(CF24A_AK_SBR, F) , F.DEPTID , F.CATEGORY , F.COST_TYPE , F.TRANS_CODE , F.CF_SEQNO , %subrec(AM_CF1_N_SBR5, F) , F.QUANTITY , F.TXN_CURRENCY_CD , F.TXN_COST , F.TXN_PROCEEDS , F.CURRENCY_CD , F.COST , F.SALVAGE_VALUE , F.DEPR , F.DEPR_YTD , F.TXN_CURRENCY_CD2 , F.TXN_REMOVAL_COST , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , 0 , F.RATE_MULT , F.RATE_DIV , F.SYSTEM_SOURCE , ' ' , F.VOUCHER_ID , F.VOUCHER_LINE_NUM , F.DISTRIB_LINE_NUM , %DateNull , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , 0 , 0 , ' ' , ' ' , ' ' , ' ' , 0 , 0 , 0 , ' ' , 0 , ' ' , F.BUSINESS_UNIT_PC , F.PROJECT_ID , F.ACTIVITY_ID , F.RESOURCE_TYPE , F.DISTRIB_LINE_NUM , ' ' , ' ' , %DateNull , 0 , ' ' , %DateNull , 0 , ' ' , 0 , A.MFG_ID , A.MANUFACTURER , A.MODEL , A.PROD_VERSION , F.TRANSFER_BU , F.TRANS_IN_OUT , F.CONSOLIDATION_ID , F.MESSAGE_SET_NBR , F.MESSAGE_NBR FROM PS_INTFC_FIN F , PS_ASSET A WHERE F.BUSINESS_UNIT = A.BUSINESS_UNIT AND F.ASSET_ID = A.ASSET_ID AND NOT EXISTS ( SELECT 'X' FROM PS_INTFC_PHY_A PA WHERE PA.INTFC_ID = F.INTFC_ID AND PA.INTFC_LINE_NUM = F.INTFC_LINE_NUM AND PA.BUSINESS_UNIT = F.BUSINESS_UNIT AND PA.ASSET_ID = F.ASSET_ID AND PA.INTFC_TYPE = F.INTFC_TYPE )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
3 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
4 MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition
5 PI_ID Character(10) VARCHAR2(10) NOT NULL Physical Inventory ID
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
8 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

Prompt Table: BOOK

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 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type
11 PSDMUNIT_ID Character(30) VARCHAR2(30) NOT NULL Transaction
12 INTFC_TABLE_CD Character(1) VARCHAR2(1) NOT NULL Interface Table Code
2=Financial and Physical A
A=Physical A Only
F=Financial Only
13 INTFC_STATUS Character(3) VARCHAR2(3) NOT NULL Interface Status
CON=Consolidated
DON=Mass Changes Generated
ERR=Error
NEW=Mass Changes Not Generated
REP=Replaced by Other Records (AP)
UNI=Unitized
14 LOAD_STATUS Character(3) VARCHAR2(3) NOT NULL /* -> JMZ. PSOFT. 11-OCT-2002 */ New Status were added : HLD and INP for Asset Management. /* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated
DON=Loaded
ERR=Errored
EXC=Excluded
HLD=On Hold
INP=In Process
NEW=Pending
PGI=PO Grp Incomplete
REP=Replaced
UNI=Unitized

Default Value: NEW

15 APPROVAL_SW Character(1) VARCHAR2(1) NOT NULL Auto Approval Status

Y/N Table Edit

16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
17 FINANCIAL_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Capitalized Asset
N=Non Cap
Y=Capitalize
18 LINEAR_ASSET_SW Character(1) VARCHAR2(1) NOT NULL Linear Asset
19 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
20 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
21 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID
22 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
23 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset
24 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

Prompt Table: PROFILE_TBL

25 CAP_THRSHLD_ID Character(10) VARCHAR2(10) NOT NULL Threshold ID

Prompt Table: CAP_THR_DFN1_VW

26 DESCR_LONG Character(254) VARCHAR2(254) NOT NULL Long Description
27 ACQUISITION_DT Date(10) DATE Acquisition Date
28 IN_SERVICE_DT Date(10) DATE In Service Date
29 TRANS_DT Date(10) DATE Transaction Date
30 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
31 OPERATING_UNIT Character(8) VARCHAR2(8) NOT NULL Operating Unit ChartField

Prompt Table: %EDIT_OPER_UNIT

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

Prompt Table: %EDIT_PRODUCT

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

Prompt Table: %EDIT_FUND_CODE

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

Prompt Table: %EDIT_CLASS_FLD

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

Prompt Table: %EDIT_PROG_CODE

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

Prompt Table: %EDIT_BUD_REF

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

Prompt Table: AFFILIATE_VW

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

Prompt Table: %EDIT_INTRA01

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

Prompt Table: %EDIT_INTRA02

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

Prompt Table: %EDIT_CHARTFLD1

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

Prompt Table: %EDIT_CHARTFLD2

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

Prompt Table: %EDIT_CHARTFLD3

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

Prompt Table: %EDIT_DEPT

44 CATEGORY Character(5) VARCHAR2(5) NOT NULL Asset Category

Prompt Table: CATEGORY_TBL

45 COST_TYPE Character(1) VARCHAR2(1) NOT NULL Cost Type

Prompt Table: COST_TYPE_TBL

46 TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Transaction Code

Prompt Table: TRANS_CODE_VW

47 CF_SEQNO Number(6,0) INTEGER NOT NULL Chartfield Sequence Number
48 RESOURCE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Category
49 RESOURCE_SUB_CAT Character(5) VARCHAR2(5) NOT NULL Subcategory
50 ANALYSIS_TYPE Character(3) VARCHAR2(3) NOT NULL Analysis Type
51 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
52 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency
53 TXN_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Cost
54 TXN_PROCEEDS Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Proceeds
55 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
56 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
57 SALVAGE_VALUE Signed Number(28,3) DECIMAL(26,3) NOT NULL Salvage Value
58 DEPR Signed Number(28,3) DECIMAL(26,3) NOT NULL Depreciation Amt
59 DEPR_YTD Signed Number(28,3) DECIMAL(26,3) NOT NULL Year to Date Depreciation
60 TXN_CURRENCY_CD2 Character(3) VARCHAR2(3) NOT NULL Transaction Currency Display
61 TXN_REMOVAL_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Removal Cost
62 TXN_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Transaction Amount
63 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
64 SALETX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Sales Tax Amount
65 USETAX_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
66 FREIGHT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Freight Amount
67 MISC_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Misc. Amount
68 VAT_INV_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amount
69 VAT_NRCVR_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Non Recoverable
70 VAT_RCVRY_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt
71 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount
72 MERCH_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Merchandise Amount
73 SALETX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Sales Tax Amount
74 USETAX_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Use Tax Amount
75 FREIGHT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Freight Amount
76 MISC_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Base Misc. Amount
77 VAT_INV_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Invoice Amt Base Curr
78 VAT_NRCVR_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT NonRecoverable Amount
79 VAT_RCVRY_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL VAT Recovery Amt in Base Curr
80 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier
81 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor
82 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
83 BUSINESS_UNIT_AP Character(5) VARCHAR2(5) NOT NULL AP Business Unit

Prompt Table: SP_BU_AP_NONVW

84 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

Prompt Table: VCHR_VW_AM

85 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
86 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
87 INVOICE_DT Date(10) DATE Invoice Date
88 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

Prompt Table: VNDR_FS

89 VENDOR_NAME Character(30) VARCHAR2(30) NOT NULL Supplier Name
90 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
91 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

Prompt Table: SP_BU_PM_NONVW

92 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

Prompt Table: PO_HDR_VW_AM

93 PO_LINE_NBR Number(5,0) INTEGER NOT NULL Purchase Order Line Number
94 PO_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL PO Distribution Line Number
95 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
96 REFERENCE_ID Character(10) VARCHAR2(10) NOT NULL Reference ID
97 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
98 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
99 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
100 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
101 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
102 RECV_DIST_LINE_NUM Number(5,0) INTEGER NOT NULL Receiver Distrib Line
103 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID
104 PO_GRP_SEQ_NUM Number(8,0) INTEGER NOT NULL Procurement Group Sequence
105 PRIMARY_UNIT Character(1) VARCHAR2(1) NOT NULL Primary Unit
N=No
Y=Yes

Y/N Table Edit

106 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
107 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: %EDIT_PROJECT

108 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
109 RESOURCE_TYPE Character(5) VARCHAR2(5) NOT NULL Source Type
110 DISTRIB_LINE_NUM2 Number(5,0) INTEGER NOT NULL Distribution Line
111 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSONAL_DATA

112 CUSTODIAN Character(30) VARCHAR2(30) NOT NULL Custodian
113 CUSTODIAN_EFFDT Date(10) DATE Asset Custodian Effective Dt
114 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
115 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

116 LOCATION_EFFDT Date(10) DATE Location Effective Date
117 LOCATION_EFFSEQ Number(3,0) SMALLINT NOT NULL Asset Location Effective Seq
118 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID

Prompt Table: AM_AREA_TBL

119 SEQUENCE_NBR_6 Number(6,0) INTEGER NOT NULL Sequence
120 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

Prompt Table: MANUFACTURER

121 MANUFACTURER Character(60) VARCHAR2(60) NOT NULL Manufacturer Name
122 MODEL Character(30) VARCHAR2(30) NOT NULL Model

Prompt Table: MFG_MODEL

123 PROD_VERSION Character(10) VARCHAR2(10) NOT NULL Product Version
124 TRANSFER_BU Character(5) VARCHAR2(5) NOT NULL Transfer Business Unit
125 TRANS_IN_OUT Character(1) VARCHAR2(1) NOT NULL Transaction In/Out
I=In
M=IUT Proceeds Markup
O=Out
126 CONSOLIDATION_ID Number(8,0) INTEGER NOT NULL Consolidation ID
127 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
128 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.