| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
|---|
| 1 | ASI_Order_By  | ASI_Order_By | Long Integer | LI_14 | 14 |
| 2 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 |
| 3 | IVDOCTYP | IV Document Type | Integer | DDL_IV_Document_Type | 0 |
| 4 | ASI_Document_Status | ASI_Document_Status | Integer | INT | 0 |
| 5 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 |
| Key to the Item Master (IV00101).
SELECT
['SmartList Inventory Transaction Amount'].ITEMNMBR AS 'SmartList Inventory Transaction Amount-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SmartList Inventory Transaction Amount'].ITEMNMBR = ['Item Master'].ITEMNMBR |
| 6 | LNSEQNBR | Line SEQ Number | Currency | Sequence_Number | 19 |
| 7 | UOFM | U Of M | String | U_Of_M | 8 |
| 8 | QTYBSUOM | QTY In Base U Of M | Currency | DLR17_QTY_RBS0_STR | 17 |
| 9 | TRXQTY | TRX QTY | Currency | DLR17_QTY_RBS0_STR | 17 |
| 10 | UNITCOST | Unit Cost | Currency | DLR17_RBS0_UTR$ | 17 |
| 11 | EXTDCOST | Extended Cost | Currency | DLR17_RBS0_UTR$ | 17 |
| 12 | TRXLOCTN | TRX Location | String | STR10_Location_Code | 10 |
| Key to the Site Setup (IV40700).
SELECT
['SmartList Inventory Transaction Amount'].TRXLOCTN AS 'SmartList Inventory Transaction Amount-TRX Location'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SmartList Inventory Transaction Amount'].TRXLOCTN = ['Site Setup'].LOCNCODE |
| 13 | TRNSTLOC | Transfer To Location | String | STR10_Location_Code | 10 |
| Key to the Site Setup (IV40700).
SELECT
['SmartList Inventory Transaction Amount'].TRNSTLOC AS 'SmartList Inventory Transaction Amount-Transfer To Location'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SmartList Inventory Transaction Amount'].TRNSTLOC = ['Site Setup'].LOCNCODE |
| 14 | TRFQTYTY | Transfer From QTY Type | Integer | DDL_QTY_Type | 0 |
| 15 | TRTQTYTY | Transfer To QTY Type | Integer | DDL_QTY_Type | 0 |
| 16 | IVIVINDX | IV IV Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].IVIVINDX AS 'SmartList Inventory Transaction Amount-IV IV Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].IVIVINDX = ['Account Index Master'].ACTINDX |
| 17 | IVIVOFIX | IV IV Offset Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].IVIVOFIX AS 'SmartList Inventory Transaction Amount-IV IV Offset Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].IVIVOFIX = ['Account Index Master'].ACTINDX |
| 18 | IVWLNMSG | IV WORK LINE Messages | Long Integer | IV_WORK_LINE_Messages | 0 |
| 19 | TRXSORCE | TRX Source | String | STR13 | 13 |
| 20 | DOCDATE | Document Date | Date | DT | 8 |
| 21 | HSTMODUL | History Module | String | STR3 | 3 |
| 22 | CUSTNMBR | Customer Number | String | STR15_RM_Customer_Number | 15 |
| Key to the RM Customer MSTR (RM00101).
SELECT
['SmartList Inventory Transaction Amount'].CUSTNMBR AS 'SmartList Inventory Transaction Amount-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SmartList Inventory Transaction Amount'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR |
| 23 | ITEMDESC | Item Description | String | STR100 | 100 |
| 24 | NOTEINDX | Note Index | Currency | DLR14 | 14 |
| Key to the Record Notes Master (SY03900).
SELECT
['SmartList Inventory Transaction Amount'].NOTEINDX AS 'SmartList Inventory Transaction Amount-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SmartList Inventory Transaction Amount'].NOTEINDX = ['Record Notes Master'].NOTEINDX |
| 25 | ITMSHNAM | Item Short Name | String | STR15 | 15 |
| 26 | ITEMTYPE | Item Type | Integer | DDL_Item_Type | 0 |
| 27 | ITMGEDSC | Item Generic Description | String | STR10 | 10 |
| 28 | STNDCOST | Standard Cost | Currency | DLR17_RBS0_UTR$ | 17 |
| 29 | CURRCOST | Current Cost | Currency | DLR17_RBS0_UTR$ | 17 |
| 30 | LISTPRCE | List Price | Currency | DLR17_RBS0_STR$ | 17 |
| 31 | ITEMSHWT | Item Shipping Weight | Long Integer | LI6_RBS2_UT | 6 |
| 32 | DECPLQTY | Decimal Places QTYS | Integer | DDL_Decimal_Places_QTYS | 0 |
| 33 | DECPLCUR | Decimal Places Currency | Integer | DDL_Decimal_Places_Dollars | 0 |
| 34 | ITMTSHID | Item Tax Schedule ID | String | STR15_LBAU | 15 |
| Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
SELECT
['SmartList Inventory Transaction Amount'].ITMTSHID AS 'SmartList Inventory Transaction Amount-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Inventory Transaction Amount'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID |
| 35 | TAXOPTNS | Tax Options | Integer | DDL_Tax_Options | 0 |
| 36 | COMMCODE | Commission Code | String | STR15_LBAU | 15 |
| 37 | IVCOGSIX | IV COGS Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].IVCOGSIX AS 'SmartList Inventory Transaction Amount-IV COGS Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].IVCOGSIX = ['Account Index Master'].ACTINDX |
| 38 | IVSLSIDX | IV Sales Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].IVSLSIDX AS 'SmartList Inventory Transaction Amount-IV Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].IVSLSIDX = ['Account Index Master'].ACTINDX |
| 39 | IVSLDSIX | IV Sales Discounts Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].IVSLDSIX AS 'SmartList Inventory Transaction Amount-IV Sales Discounts Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].IVSLDSIX = ['Account Index Master'].ACTINDX |
| 40 | IVSLRNIX | IV Sales Returns Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].IVSLRNIX AS 'SmartList Inventory Transaction Amount-IV Sales Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].IVSLRNIX = ['Account Index Master'].ACTINDX |
| 41 | IVINUSIX | IV In Use Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].IVINUSIX AS 'SmartList Inventory Transaction Amount-IV In Use Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].IVINUSIX = ['Account Index Master'].ACTINDX |
| 42 | IVINSVIX | IV In Service Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].IVINSVIX AS 'SmartList Inventory Transaction Amount-IV In Service Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].IVINSVIX = ['Account Index Master'].ACTINDX |
| 43 | IVDMGIDX | IV Damaged Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].IVDMGIDX AS 'SmartList Inventory Transaction Amount-IV Damaged Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].IVDMGIDX = ['Account Index Master'].ACTINDX |
| 44 | IVVARIDX | IV Variances Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].IVVARIDX AS 'SmartList Inventory Transaction Amount-IV Variances Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].IVVARIDX = ['Account Index Master'].ACTINDX |
| 45 | DPSHPIDX | Drop Ship Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].DPSHPIDX AS 'SmartList Inventory Transaction Amount-Drop Ship Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].DPSHPIDX = ['Account Index Master'].ACTINDX |
| 46 | PURPVIDX | Purchase Price Variance Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].PURPVIDX AS 'SmartList Inventory Transaction Amount-Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].PURPVIDX = ['Account Index Master'].ACTINDX |
| 47 | IVRETIDX | Inventory Returns Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].IVRETIDX AS 'SmartList Inventory Transaction Amount-Inventory Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].IVRETIDX = ['Account Index Master'].ACTINDX |
| 48 | ASMVRIDX | Assembly Variance Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].ASMVRIDX AS 'SmartList Inventory Transaction Amount-Assembly Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].ASMVRIDX = ['Account Index Master'].ACTINDX |
| 49 | ITMCLSCD | Item Class Code | String | STR10_Class_ID | 10 |
| Key to the Item Class Setup (IV40400).
SELECT
['SmartList Inventory Transaction Amount'].ITMCLSCD AS 'SmartList Inventory Transaction Amount-Item Class Code'
,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
IV40400 AS ['Item Class Setup']
ON
['SmartList Inventory Transaction Amount'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD |
| 50 | ITMTRKOP | Item Tracking Option | Integer | DDL_Track | 0 |
| 51 | LOTTYPE | Lot Type | String | STR10_Lot_Type | 10 |
| 52 | KPERHIST | Keep Period History | Boolean | CB_Keep_Period_History | 0 |
| 53 | KPTRXHST | Keep Trx History | Boolean | CB_Keep_Trx_History | 0 |
| 54 | KPCALHST | Keep Calendar History | Boolean | CB_Keep_Calendar_History | 0 |
| 55 | KPDSTHST | Keep Distribution History | Boolean | CB_Keep_Dist_History | 0 |
| 56 | ALWBKORD | Allow Back Orders | Boolean | CB_Allow_Back_Orders | 0 |
| 57 | VCTNMTHD | Valuation Method | Integer | DDL_Valuation_Method | 0 |
| 58 | UOMSCHDL | U Of M Schedule | String | STR10_Schedule | 10 |
| Key to the Inventory U of M Schedule Setup (IV40201).
SELECT
['SmartList Inventory Transaction Amount'].UOMSCHDL AS 'SmartList Inventory Transaction Amount-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['SmartList Inventory Transaction Amount'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL |
| 59 | ObjRef1 | ObjRef1 | Invalid storage type 30 | Reference | 0 |
| 60 | ALTITEM1 | Alternate Item 1 | String | STR30_Item_Number | 30 |
| 61 | ALTITEM2 | Alternate Item 2 | String | STR30_Item_Number | 30 |
| 62 | USCATVLS_1 | User Category Values[1] | String | User_Category_Value | 10 |
| 63 | USCATVLS_2 | User Category Values[2] | String | User_Category_Value | 10 |
| 64 | USCATVLS_3 | User Category Values[3] | String | User_Category_Value | 10 |
| 65 | USCATVLS_4 | User Category Values[4] | String | User_Category_Value | 10 |
| 66 | USCATVLS_5 | User Category Values[5] | String | User_Category_Value | 10 |
| 67 | USCATVLS_6 | User Category Values[6] | String | User_Category_Value | 10 |
| 68 | MSTRCDTY | Master Record Type | Integer | INT1 | 1 |
| 69 | MODIFDT | Modified Date | Date | DT | 8 |
| 70 | CREATDDT | Created Date | Date | DT | 8 |
| 71 | WRNTYDYS | Warranty Days | Integer | INT4 | 4 |
| 72 | PRCLEVEL | PriceLevel | String | STR10_LBAU | 10 |
| 73 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 |
| Key to the Site Setup (IV40700).
SELECT
['SmartList Inventory Transaction Amount'].LOCNCODE AS 'SmartList Inventory Transaction Amount-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SmartList Inventory Transaction Amount'].LOCNCODE = ['Site Setup'].LOCNCODE |
| 74 | ASI_Main_IV_IV_Index | ASI_Main_IV_IV_Index | Long Integer | LI_14 | 14 |
| 75 | ASI_Main_IV_IV_Offset_In | ASI_Main_IV_IV_Offset_Index | Long Integer | LI_14 | 14 |
| 76 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 |
| 77 | BCHSOURC | Batch Source | String | STR15 | 15 |
| 78 | RCDOCNUM | Recurring Document Number | String | STR20_Document_Number | 20 |
| 79 | MDFUSRID | Modified User ID | String | STR15 | 15 |
| Key to the Users Master (SY01400).
SELECT
['SmartList Inventory Transaction Amount'].MDFUSRID AS 'SmartList Inventory Transaction Amount-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SmartList Inventory Transaction Amount'].MDFUSRID = ['Users Master'].USERID |
| 80 | POSTEDDT | Posted Date | Date | DATE | 6 |
| 81 | PTDUSRID | Posted User ID | String | STR15 | 15 |
| Key to the Users Master (SY01400).
SELECT
['SmartList Inventory Transaction Amount'].PTDUSRID AS 'SmartList Inventory Transaction Amount-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SmartList Inventory Transaction Amount'].PTDUSRID = ['Users Master'].USERID |
| 82 | GLPOSTDT | GL Posting Date | Date | DT | 8 |
| 83 | PSTGSTUS | Posting Status | Integer | INT | 0 |
| 84 | TRXQTYTL | TRX QTY Total | Currency | DLR17_QTY_RBS0_UTR | 17 |
| 85 | IVWHRMSG | IV WORK HDR Messages | Long Integer | IV_WORK_HDR_Messages | 0 |
| 86 | ASI_Favorite_Sequence | ASI_Favorite_Sequence | Long Integer | ASI_LI_10_RU | 10 |
| 87 | ABCCODE | ABC Code | Integer | DDL_ABC_Code | 0 |
| 88 | CGSINFLX | COGS Inflation Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].CGSINFLX AS 'SmartList Inventory Transaction Amount-COGS Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].CGSINFLX = ['Account Index Master'].ACTINDX |
| 89 | CGSMCIDX | COGS Monetary Correction Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].CGSMCIDX AS 'SmartList Inventory Transaction Amount-COGS Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].CGSMCIDX = ['Account Index Master'].ACTINDX |
| 90 | IVINFIDX | Inventory Inflation Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].IVINFIDX AS 'SmartList Inventory Transaction Amount-Inventory Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].IVINFIDX = ['Account Index Master'].ACTINDX |
| 91 | INVMCIDX | Inventory Monetary Correction Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].INVMCIDX AS 'SmartList Inventory Transaction Amount-Inventory Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].INVMCIDX = ['Account Index Master'].ACTINDX |
| 92 | ITEMCODE | Item Code | String | STR15 | 15 |
| 93 | KTACCTSR | Kit COGS Account Source | Integer | GB | 0 |
| 94 | LASTGENSN | Last Generated Serial Number | String | STR20_LBAU | 20 |
| 95 | PriceGroup | Price Group | String | STR10_LBAU | 10 |
| 96 | PRICMTHD | Price Method | Integer | DDL_Price_Method | 0 |
| 97 | PINFLIDX | Purch Inflation Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].PINFLIDX AS 'SmartList Inventory Transaction Amount-Purch Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].PINFLIDX = ['Account Index Master'].ACTINDX |
| 98 | PURMCIDX | Purch Monetary Correction Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].PURMCIDX AS 'SmartList Inventory Transaction Amount-Purch Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].PURMCIDX = ['Account Index Master'].ACTINDX |
| 99 | PRCHSUOM | Purchasing U Of M | String | U_Of_M | 8 |
| 100 | SELNGUOM | Selling U Of M | String | U_Of_M | 8 |
| 101 | TCC | Tax Commodity Code | String | STR30_VAT | 30 |
| 102 | UPPVIDX | Unrealized Purchase Price Variance Index | Long Integer | LI_14 | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['SmartList Inventory Transaction Amount'].UPPVIDX AS 'SmartList Inventory Transaction Amount-Unrealized Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP19 AS ['SmartList Inventory Transaction Amount']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Inventory Transaction Amount'].UPPVIDX = ['Account Index Master'].ACTINDX |
| 103 | LOCNCODE1 | ASI_Location_Code | String | STR10_Location_Code | 10 |
| 104 | USAGETYPE | Usage Type | Integer | INT | 0 |
| 105 | SRCRFRNCNMBR | Source Reference Number | String | STR30 | 30 |
| 106 | SOURCEINDICATOR | Source Indicator | Integer | DDL_Source_Indicator | 0 |
| 107 | UMSCHDSC | U Of M Schedule Description | String | STR30 | 30 |
