Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP21
Product: SmartList (1493)
Series:
Display Name: SmartList Purchasing Line Items
Physical Name: ASIEXP21
Technical Name: ASI_POP_LINE_Items_ExplorerSeq 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 PONUMBER PO Number String STR17_POP_Number 17 3 ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer ASI_LI_10_RU 10 4 ORD Ord Long Integer LI_Sequence_Number 10 5 POLNESTA PO Line Status Integer DDL_PO_Line_Status 0 6 POTYPE PO Type Integer DDL_POP_PO_Type 0 7 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].ITEMNMBR AS 'SmartList Purchasing Line Items-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
IV00101 AS ['Item Master']
ON
['SmartList Purchasing Line Items'].ITEMNMBR = ['Item Master'].ITEMNMBR8 ITEMDESC Item Description String STR100 100 9 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].VENDORID AS 'SmartList Purchasing Line Items-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['SmartList Purchasing Line Items'].VENDORID = ['PM Vendor Master File'].VENDORID10 VNDITNUM Vendor Item Number String Item_Number 30 11 VNDITDSC Vendor Item Description String STR100 100 12 NONINVEN Non IV Integer INT1 1 13 UOFM U Of M String U_Of_M 8 14 UMQTYINB U Of M QTY In Base Currency DLR17_QTY_RBS0_STR 17 15 QTYORDER QTY Ordered Currency DLR17_QTY_RBS0_UTR 17 16 QTYCANCE QTY Canceled Currency DLR17_QTY_RBS0_UTR 17 17 QTYCMTBASE QTY Committed In Base Currency DLR17_QTY_RBS0_STR 17 18 QTYUNCMTBASE QTY Uncommitted In Base Currency DLR17_QTY_RBS0_STR 17 19 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 20 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 21 INVINDX Inventory Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].INVINDX AS 'SmartList Purchasing Line Items-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].INVINDX = ['Account Index Master'].ACTINDX22 REQDATE Required Date Date DATE_L 0 23 PRMDATE Promised Date Date DATE_L 0 24 PRMSHPDTE Promised Ship Date Date DATE_L 0 25 REQSTDBY Requested By String STR20_LB 20 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].REQSTDBY AS 'SmartList Purchasing Line Items-Requested By'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SmartList Purchasing Line Items'].REQSTDBY = ['Users Master'].USERID26 COMMNTID Comment ID String STR15_Comment_ID 15 Key to the Comment Master (SY04200).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].COMMNTID AS 'SmartList Purchasing Line Items-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['SmartList Purchasing Line Items'].COMMNTID = ['Comment Master'].COMMNTID27 DOCTYPE Document Type Integer DDL_Document_Type 0 28 POLNEARY_1 PO Line Note ID Array[1] Currency DLR14 14 29 POLNEARY_2 PO Line Note ID Array[2] Currency DLR14 14 30 POLNEARY_3 PO Line Note ID Array[3] Currency DLR14 14 31 POLNEARY_4 PO Line Note ID Array[4] Currency DLR14 14 32 POLNEARY_5 PO Line Note ID Array[5] Currency DLR14 14 33 POLNEARY_6 PO Line Note ID Array[6] Currency DLR14 14 34 POLNEARY_7 PO Line Note ID Array[7] Currency DLR14 14 35 POLNEARY_8 PO Line Note ID Array[8] Currency DLR14 14 36 POLNEARY_9 PO Line Note ID Array[9] Currency DLR14 14 37 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 38 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 39 ITMTRKOP Item Tracking Option Integer DDL_Track 0 40 BRKFLD1 Break Field 1 Integer INT1 1 41 PO_Line_Status_Orig PO Line Status Orig Integer DDL_PO_Line_Status 0 42 QTY_Canceled_Orig QTY Canceled Orig Currency DLR17_QTY_RBS0_UTR 17 43 OPOSTSUB Originating Posted Subtotal Currency DLR17_RBS0_STR$ 17 44 JOBNUMBR Job Number String STR17_LBAU 17 45 COSTCODE Cost Code String STR27 27 46 COSTTYPE Cost Code Type Integer INT3_RB0_U 3 47 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].CURNCYID AS 'SmartList Purchasing Line Items-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SmartList Purchasing Line Items'].CURNCYID = ['Currency Setup'].CURNCYID48 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].CURRNIDX AS 'SmartList Purchasing Line Items-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SmartList Purchasing Line Items'].CURRNIDX = ['Currency Setup'].CURRNIDX49 XCHGRATE Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 50 RATECALC Rate Calc Method Integer INT 0 51 DENXRATE Denomination Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 52 ORUNTCST Originating Unit Cost Currency DLR17_RBS0_UTR$ 17 53 OREXTCST Originating Extended Cost Currency DLR17_RBS0_UTR$ 17 54 LINEORIGIN Line Origin Integer DDL_Line_Origin 0 55 FREEONBOARD Free On Board Integer DDL_Free_On_Board 0 56 ODECPLCU Originating Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 57 Capital_Item Capital Item Boolean CB_Capital_Item 0 58 Product_Indicator Product Indicator Integer DDL_Product_Indicator 0 59 Source_Document_Number Source Document Number String STR11_Document_Number 11 60 Source_Document_Line_Num Source Document Line Number Integer INT4 4 61 ASI_Document_Status ASI_Document_Status Integer INT 0 62 STATGRP Status Group Integer INT1 1 63 USER2ENT User To Enter String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].USER2ENT AS 'SmartList Purchasing Line Items-User To Enter'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SmartList Purchasing Line Items'].USER2ENT = ['Users Master'].USERID64 CONFIRM1 Confirm With String STR20 20 65 DOCDATE Document Date Date DT 8 66 LSTEDTDT Last Edit Date Date DT_Date 6 67 LSTPRTDT Last Printed Date Date DATE_L 0 68 REQTNDT Requisition Date Date DATE_L 0 69 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].SHIPMTHD AS 'SmartList Purchasing Line Items-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['SmartList Purchasing Line Items'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD70 TXRGNNUM Tax Registration Number String STR25 25 71 REMSUBTO Remaining Subtotal Currency DLR17_RBS0_UTR$ 17 72 SUBTOTAL Subtotal Currency DLR17_RBS0_STR$ 17 73 TRDISAMT Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 74 FRTAMNT Freight Amount Currency DLR17_RBS0_UTR$ 17 75 MSCCHAMT Misc Charges Amount Currency DLR17_RBS0_UTR$ 17 76 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 77 VENDNAME Vendor Name String STR64_Vendor_Name 64 78 MINORDER Minimum Order Currency DLR17_$U2 17 79 VADCDPAD Vendor Address Code - Purchase Address String STR15_Address_Code 15 Partial key to the PM Address MSTR (PM00300).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].VADCDPAD AS 'SmartList Purchasing Line Items-Vendor Address Code - Purchase Address'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList Purchasing Line Items'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
AND
['SmartList Purchasing Line Items'].VENDORID = ['PM Address MSTR'].VENDORID80 CMPANYID Company ID Integer INT5 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].CMPANYID AS 'SmartList Purchasing Line Items-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['SmartList Purchasing Line Items'].CMPANYID = ['Company Master'].CMPANYID81 PRBTADCD Primary Billto Address Code String STR15_LBAU 15 82 PRSTADCD Primary Shipto Address Code String STR15_LBAU 15 83 CMPNYNAM Company Name String STR64_Company_Name 64 84 CONTACT Contact String STR60 60 85 ADDRESS1 Address 1 String STR60 60 86 ADDRESS2 Address 2 String STR60 60 87 ADDRESS3 Address 3 String STR60 60 88 CITY City String STR35 35 89 STATE State String STR30_State 29 90 ZIPCODE Zip Code String STR10 10 91 COUNTRY Country String STR60 60 92 PHONE1 Phone 1 String Phone_Number 14 93 PHONE2 Phone 2 String Phone_Number 14 94 FAX Fax String STR14_FAX 14 95 PYMTRMID Payment Terms ID String STR20_Payment_Terms_ID 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PYMTRMID AS 'SmartList Purchasing Line Items-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['SmartList Purchasing Line Items'].PYMTRMID = ['Payment Terms Master'].PYMTRMID96 DSCDLRAM Discount Dollar Amount Currency DLR11_RBS0_UTR$ 11 97 DSCPCTAM Discount Percent Amount Integer INT5_%2 5 98 DISAMTAV Discount Amount Available Currency DLR17_RBS0_UTR$ 17 99 DISCDATE Discount Date Date DT 8 100 DUEDATE Due Date Date DT 8 101 TRDPCTPR Trade Discount Percent (Precise) Currency (Variable) Trade Discount Percent (Precise) 23 102 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].CUSTNMBR AS 'SmartList Purchasing Line Items-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SmartList Purchasing Line Items'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR103 TIMESPRT Times Printed Integer INT4_U0 4 104 CREATDDT Created Date Date DT 8 105 MODIFDT Modified Date Date DT 8 106 PONOTIDS_1 PO Note ID Array[1] Currency DLR14 14 107 PONOTIDS_2 PO Note ID Array[2] Currency DLR14 14 108 PONOTIDS_3 PO Note ID Array[3] Currency DLR14 14 109 PONOTIDS_4 PO Note ID Array[4] Currency DLR14 14 110 PONOTIDS_5 PO Note ID Array[5] Currency DLR14 14 111 PONOTIDS_6 PO Note ID Array[6] Currency DLR14 14 112 PONOTIDS_7 PO Note ID Array[7] Currency DLR14 14 113 PONOTIDS_8 PO Note ID Array[8] Currency DLR14 14 114 PONOTIDS_9 PO Note ID Array[9] Currency DLR14 14 115 PONOTIDS_10 PO Note ID Array[10] Currency DLR14 14 116 PONOTIDS_11 PO Note ID Array[11] Currency DLR14 14 117 PONOTIDS_12 PO Note ID Array[12] Currency DLR14 14 118 PONOTIDS_13 PO Note ID Array[13] Currency DLR14 14 119 PONOTIDS_14 PO Note ID Array[14] Currency DLR14 14 120 PONOTIDS_15 PO Note ID Array[15] Currency DLR14 14 121 COMMENT_1 Comment[1] String STR50 50 122 COMMENT_2 Comment[2] String STR50 50 123 COMMENT_3 Comment[3] String STR50 50 124 COMMENT_4 Comment[4] String STR50 50 125 CANCSUB Canceled Subtotal Currency DLR17_RBS0_STR$ 17 126 RATETPID Rate Type ID String STR15_Rate_Type_ID 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].RATETPID AS 'SmartList Purchasing Line Items-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['SmartList Purchasing Line Items'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID127 EXGTBLID Exchange Table ID String STR15_Exchange_Table_ID 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].EXGTBLID AS 'SmartList Purchasing Line Items-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['SmartList Purchasing Line Items'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID128 EXCHDATE Exchange Date Date DT_Date 6 129 TIME1 Time Time TM6 6 130 MCTRXSTT MC Transaction State Integer INT1 1 131 OREMSUBT Originating Remaining Subtotal Currency DLR17_RBS0_UTR$ 17 132 ORSUBTOT Originating Subtotal Currency DLR17_RBS0_STR$ 17 133 Originating_Canceled_Sub Originating Canceled Subtotal Currency DLR17_RBS0_STR$ 17 134 ORTDISAM Originating Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 135 ORFRTAMT Originating Freight Amount Currency DLR17_RBS0_UTR$ 17 136 OMISCAMT Originating Misc Charges Amount Currency DLR17_RBS0_UTR$ 17 137 ORTAXAMT Originating Tax Amount Currency DLR17_RBS0_UTR$ 17 138 ORDDLRAT Originating Discount Dollar Amount Currency DLR11_RBS0_UTR$ 11 139 ODISAMTAV Originating Discount Amount Available Currency DLR17_RBS0_UTR$ 17 140 BUYERID Buyer ID String STR15_User_ID 15 141 ONORDAMT On Order Amount Currency DLR19_RBS0_UTR$ 19 142 ORORDAMT Originating On Order Amount Currency DLR19_RBS0_UTR$ 19 143 HOLD Hold Boolean CB_Hold 0 144 ONHOLDDATE On Hold Date Date DT 8 145 ONHOLDBY On Hold By String STR15_User_ID 15 146 HOLDREMOVEDATE Hold Remove Date Date DT 8 147 HOLDREMOVEBY Hold Remove By String STR15_User_ID 15 148 ALLOWSOCMTS Allow SO Commitments Boolean CB_AllowSOCommitments 0 149 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].NOTEINDX AS 'SmartList Purchasing Line Items-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SmartList Purchasing Line Items'].NOTEINDX = ['Record Notes Master'].NOTEINDX150 ITMSHNAM Item Short Name String STR15 15 151 ITEMTYPE Item Type Integer DDL_Item_Type 0 152 ITMGEDSC Item Generic Description String STR10 10 153 STNDCOST Standard Cost Currency DLR17_RBS0_UTR$ 17 154 CURRCOST Current Cost Currency DLR17_RBS0_UTR$ 17 155 LISTPRCE List Price Currency DLR17_RBS0_STR$ 17 156 ITEMSHWT Item Shipping Weight Long Integer LI6_RBS2_UT 6 157 ITMTSHID Item Tax Schedule ID String STR15_LBAU 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].ITMTSHID AS 'SmartList Purchasing Line Items-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Purchasing Line Items'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID158 TAXOPTNS Tax Options Integer DDL_Tax_Options 0 159 COMMCODE Commission Code String STR15_LBAU 15 160 IVIVINDX IV IV Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].IVIVINDX AS 'SmartList Purchasing Line Items-IV IV Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].IVIVINDX = ['Account Index Master'].ACTINDX161 IVIVOFIX IV IV Offset Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].IVIVOFIX AS 'SmartList Purchasing Line Items-IV IV Offset Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].IVIVOFIX = ['Account Index Master'].ACTINDX162 IVCOGSIX IV COGS Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].IVCOGSIX AS 'SmartList Purchasing Line Items-IV COGS Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].IVCOGSIX = ['Account Index Master'].ACTINDX163 IVSLSIDX IV Sales Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].IVSLSIDX AS 'SmartList Purchasing Line Items-IV Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].IVSLSIDX = ['Account Index Master'].ACTINDX164 IVSLDSIX IV Sales Discounts Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].IVSLDSIX AS 'SmartList Purchasing Line Items-IV Sales Discounts Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].IVSLDSIX = ['Account Index Master'].ACTINDX165 IVSLRNIX IV Sales Returns Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].IVSLRNIX AS 'SmartList Purchasing Line Items-IV Sales Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].IVSLRNIX = ['Account Index Master'].ACTINDX166 IVINUSIX IV In Use Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].IVINUSIX AS 'SmartList Purchasing Line Items-IV In Use Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].IVINUSIX = ['Account Index Master'].ACTINDX167 IVINSVIX IV In Service Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].IVINSVIX AS 'SmartList Purchasing Line Items-IV In Service Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].IVINSVIX = ['Account Index Master'].ACTINDX168 IVDMGIDX IV Damaged Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].IVDMGIDX AS 'SmartList Purchasing Line Items-IV Damaged Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].IVDMGIDX = ['Account Index Master'].ACTINDX169 IVVARIDX IV Variances Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].IVVARIDX AS 'SmartList Purchasing Line Items-IV Variances Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].IVVARIDX = ['Account Index Master'].ACTINDX170 DPSHPIDX Drop Ship Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].DPSHPIDX AS 'SmartList Purchasing Line Items-Drop Ship Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].DPSHPIDX = ['Account Index Master'].ACTINDX171 PURPVIDX Purchase Price Variance Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PURPVIDX AS 'SmartList Purchasing Line Items-Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PURPVIDX = ['Account Index Master'].ACTINDX172 IVRETIDX Inventory Returns Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].IVRETIDX AS 'SmartList Purchasing Line Items-Inventory Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].IVRETIDX = ['Account Index Master'].ACTINDX173 ASMVRIDX Assembly Variance Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].ASMVRIDX AS 'SmartList Purchasing Line Items-Assembly Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].ASMVRIDX = ['Account Index Master'].ACTINDX174 ITMCLSCD Item Class Code String STR10_Class_ID 10 Key to the Item Class Setup (IV40400).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].ITMCLSCD AS 'SmartList Purchasing Line Items-Item Class Code'
,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
IV40400 AS ['Item Class Setup']
ON
['SmartList Purchasing Line Items'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD175 LOTTYPE Lot Type String STR10_Lot_Type 10 176 KPERHIST Keep Period History Boolean CB_Keep_Period_History 0 177 KPTRXHST Keep Trx History Boolean CB_Keep_Trx_History 0 178 KPCALHST Keep Calendar History Boolean CB_Keep_Calendar_History 0 179 KPDSTHST Keep Distribution History Boolean CB_Keep_Dist_History 0 180 ALWBKORD Allow Back Orders Boolean CB_Allow_Back_Orders 0 181 VCTNMTHD Valuation Method Integer DDL_Valuation_Method 0 182 UOMSCHDL U Of M Schedule String STR10_Schedule 10 Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].UOMSCHDL AS 'SmartList Purchasing Line Items-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['SmartList Purchasing Line Items'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL183 ALTITEM1 Alternate Item 1 String STR30_Item_Number 30 184 ALTITEM2 Alternate Item 2 String STR30_Item_Number 30 185 USCATVLS_1 User Category Values[1] String User_Category_Value 10 186 USCATVLS_2 User Category Values[2] String User_Category_Value 10 187 USCATVLS_3 User Category Values[3] String User_Category_Value 10 188 USCATVLS_4 User Category Values[4] String User_Category_Value 10 189 USCATVLS_5 User Category Values[5] String User_Category_Value 10 190 USCATVLS_6 User Category Values[6] String User_Category_Value 10 191 MSTRCDTY Master Record Type Integer INT1 1 192 WRNTYDYS Warranty Days Integer INT4 4 193 PRCLEVEL PriceLevel String STR10_LBAU 10 194 VNDCHKNM Vendor Check Name String STR64_Vendor_Name 64 195 VENDSHNM Vendor Short Name String STR15 15 196 VADDCDPR Vendor Address Code - Primary String STR15_Address_Code 15 Partial key to the PM Address MSTR (PM00300).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].VADDCDPR AS 'SmartList Purchasing Line Items-Vendor Address Code - Primary'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList Purchasing Line Items'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
AND
['SmartList Purchasing Line Items'].VENDORID = ['PM Address MSTR'].VENDORID197 VADCDSFR Vendor Address Code - Ship From String STR15_Address_Code 15 Partial key to the PM Address MSTR (PM00300).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].VADCDSFR AS 'SmartList Purchasing Line Items-Vendor Address Code - Ship From'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList Purchasing Line Items'].VADCDSFR = ['PM Address MSTR'].ADRSCODE
AND
['SmartList Purchasing Line Items'].VENDORID = ['PM Address MSTR'].VENDORID198 VADCDTRO Vendor Address Code - Remit To String STR15_Address_Code 15 Partial key to the PM Address MSTR (PM00300).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].VADCDTRO AS 'SmartList Purchasing Line Items-Vendor Address Code - Remit To'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList Purchasing Line Items'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
AND
['SmartList Purchasing Line Items'].VENDORID = ['PM Address MSTR'].VENDORID199 VNDCLSID Vendor Class ID String STR10_Class_ID 10 Key to the PM Class Master File (PM00100).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].VNDCLSID AS 'SmartList Purchasing Line Items-Vendor Class ID'
,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
PM00100 AS ['PM Class Master File']
ON
['SmartList Purchasing Line Items'].VNDCLSID = ['PM Class Master File'].VNDCLSID200 VNDCNTCT Vendor Contact String STR60 60 201 UPSZONE UPS Zone String STR3 3 202 TAXSCHID Tax Schedule ID String STR15_Tax_Schedule_ID 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].TAXSCHID AS 'SmartList Purchasing Line Items-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Purchasing Line Items'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID203 ACNMVNDR Account Number With Vendor String STR20 20 204 TXIDNMBR Tax ID Number String Tax_ID_Number 11 205 VENDSTTS Vendor Status Integer DDL_Vendor_Status 0 206 PARVENID Parent Vendor ID String STR_15_Vendor_ID 15 207 TRDDISCT Trade Discount Integer INT4_%2 4 208 TEN99TYPE 1099 Type Integer 1099_Type 0 209 MINPYTYP Minimum Payment Type Integer GB_Amt_Type 0 210 MINPYPCT Minimum Payment Percent Integer INT5_%2 5 211 MINPYDLR Minimum Payment Dollar Currency DLR17_RBS0_UTR$ 17 212 MXIAFVND Maximum Invoice Amount For Vendors Integer GB 0 213 MAXINDLR Maximum Invoice Dollar Currency DLR17_$U2 17 214 COMMENT1 Comment1 String STR30 30 215 COMMENT2 Comment2 String STR30 30 216 USERDEF1 User Defined 1 String STR20 20 217 USERDEF2 User Defined 2 String STR20 20 218 CRLMTDLR Credit Limit Dollar Currency DLR17_$U2 17 219 PYMNTPRI Payment Priority String STR3 3 220 KGLDSTHS Keep GL Dist History Boolean CB_Keep_GL_Dist_History 0 221 PTCSHACF Post To Cash Account From Integer GB 0 222 CREDTLMT Credit Limit Integer GB 0 223 WRITEOFF Writeoff Integer GB 0 224 MXWOFAMT Maximum Write Off Amount Currency DLR17_$U2 17 225 SBPPSDED Subject To PPS Deductions Boolean CB_Subject_To_PPS_Deductions 0 226 PPSTAXRT PPS Tax Rate Integer INT5_%2 5 227 DXVARNUM Deduction Exemption/Variation Number String STR25 25 228 CRTCOMDT Certificate Commencing Date Date DT 8 229 CRTEXPDT Certificate Expiration Date Date DT 8 230 RTOBUTKN Reporting Obligation Undertaken Boolean CB_Reporting_Obligation 0 231 XPDTOBLG Expiration Date Obligation Boolean CB_Expiration_Date_Obligation 0 232 PRSPAYEE Prescribed Payee Boolean CB_Prescribed_Payee 0 233 PMAPINDX PM AP Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PMAPINDX AS 'SmartList Purchasing Line Items-PM AP Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PMAPINDX = ['Account Index Master'].ACTINDX234 PMCSHIDX PM Cash Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PMCSHIDX AS 'SmartList Purchasing Line Items-PM Cash Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PMCSHIDX = ['Account Index Master'].ACTINDX235 PMDAVIDX PM Discount Available Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PMDAVIDX AS 'SmartList Purchasing Line Items-PM Discount Available Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PMDAVIDX = ['Account Index Master'].ACTINDX236 PMDTKIDX PM Discount Taken Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PMDTKIDX AS 'SmartList Purchasing Line Items-PM Discount Taken Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PMDTKIDX = ['Account Index Master'].ACTINDX237 PMFINIDX PM Finance Charge Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PMFINIDX AS 'SmartList Purchasing Line Items-PM Finance Charge Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PMFINIDX = ['Account Index Master'].ACTINDX238 PMMSCHIX PM Misc Charges Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PMMSCHIX AS 'SmartList Purchasing Line Items-PM Misc Charges Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PMMSCHIX = ['Account Index Master'].ACTINDX239 PMFRTIDX PM Freight Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PMFRTIDX AS 'SmartList Purchasing Line Items-PM Freight Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PMFRTIDX = ['Account Index Master'].ACTINDX240 PMTAXIDX PM Tax Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PMTAXIDX AS 'SmartList Purchasing Line Items-PM Tax Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PMTAXIDX = ['Account Index Master'].ACTINDX241 PMWRTIDX PM Write Offs Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PMWRTIDX AS 'SmartList Purchasing Line Items-PM Write Offs Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PMWRTIDX = ['Account Index Master'].ACTINDX242 PMPRCHIX PM Purchases Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PMPRCHIX AS 'SmartList Purchasing Line Items-PM Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PMPRCHIX = ['Account Index Master'].ACTINDX243 PMRTNGIX PM Retainage Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PMRTNGIX AS 'SmartList Purchasing Line Items-PM Retainage Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PMRTNGIX = ['Account Index Master'].ACTINDX244 PMTDSCIX PM Trade Discount Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PMTDSCIX AS 'SmartList Purchasing Line Items-PM Trade Discount Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PMTDSCIX = ['Account Index Master'].ACTINDX245 ACPURIDX Accrued Purchases Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].ACPURIDX AS 'SmartList Purchasing Line Items-Accrued Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].ACPURIDX = ['Account Index Master'].ACTINDX246 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].CHEKBKID AS 'SmartList Purchasing Line Items-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['SmartList Purchasing Line Items'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID247 Revalue_Vendor Revalue Vendor Boolean CB Revalue Vendor 0 248 Post_Results_To Post Results To Integer GB 0 249 POSTATUS PO Status Integer DDL_PO_Status 0 250 HIESTBAL Highest Balance Currency DLR17_RBS0_UTR$ 17 251 CURRBLNC Current Balance Currency DLR19_RBS0_STR$ 19 252 NOINVYTD Number of Invoices YTD Long Integer LI_9U0 9 253 NOINVLIF Number of Invoices LIFE Long Integer LI_9U0 9 254 NOINVLYR Number of Invoices LYR Long Integer LI_9U0 9 255 NOPINYTD Number of Paid Invoices YTD Long Integer LI_9U0 9 256 NOPILIFE Number of Paid Invoices LIFE Long Integer LI_9U0 9 257 AMBLDTYD Amount Billed YTD Currency DLR19_RBS0_STR$ 19 258 AMBLDLIF Amount Billed LIFE Currency DLR19_RBS0_STR$ 19 259 AMBLDLYR Amount Billed LYR Currency DLR19_RBS0_STR$ 19 260 AMTPDYTD Amount Paid YTD Currency DLR19_RBS0_STR$ 19 261 AMTPDLIF Amount Paid LIFE Currency DLR19_RBS0_STR$ 19 262 AMTPDLYR Amount Paid LYR Currency DLR19_RBS0_STR$ 19 263 TEN99AYTD 1099 Amount YTD Currency DLR19_RBS0_STR$ 19 264 TEN99ALIF 1099 Amount LIFE Currency DLR19_RBS0_STR$ 19 265 TEN99ALYR 1099 Amount LYR Currency DLR19_RBS0_STR$ 19 266 DISAVYTD Discount Available YTD Currency DLR19_RBS0_STR$ 19 267 DISAVLIF Discount Available LIFE Currency DLR19_RBS0_STR$ 19 268 DISAVLYR Discount Available LYR Currency DLR19_RBS0_STR$ 19 269 DISTKYTD Discount Taken YTD Currency DLR19_RBS0_STR$ 19 270 DISTKNLF Discount Taken LIFE Currency DLR19_RBS0_STR$ 19 271 DISTKLYR Discount Taken LYR Currency DLR19_RBS0_STR$ 19 272 DISLSYTD Discount Lost YTD Currency DLR19_RBS0_STR$ 19 273 DISLSTLF Discount Lost LIFE Currency DLR19_RBS0_STR$ 19 274 DISLSLYR Discount Lost LYR Currency DLR19_RBS0_STR$ 19 275 FINCHLIF Finance Charge LIFE Currency DLR19_RBS0_STR$ 19 276 FINCHLYR Finance Charge LYR Currency DLR19_RBS0_STR$ 19 277 FINCHYTD Finance Charge YTD Currency DLR19_RBS0_STR$ 19 278 WROFSYTD Write Offs YTD Currency DLR19_RBS0_STR$ 19 279 WROFSLIF Write Offs LIFE Currency DLR19_RBS0_STR$ 19 280 WROFSLYR Write Offs LYR Currency DLR19_RBS0_STR$ 19 281 RTRNSYTD Returns YTD Currency DLR19_RBS0_STR$ 19 282 RTRNSLIF Returns LIFE Currency DLR19_RBS0_STR$ 19 283 RTRNSLYR Returns LYR Currency DLR19_RBS0_STR$ 19 284 TRDTKLIF Trade Discounts Taken LIFE Currency DLR19_RBSO_STR$ 19 285 TRDTLYR Trade Discounts Taken LYR Currency DLR19_RBSO_STR$ 19 286 TRDTYTD Trade Discounts Taken YTD Currency DLR19_RBSO_STR$ 19 287 NFNCHLIF Number of Finance Charges LIFE Long Integer LI_9U0 9 288 NFNCHLYR Number of Finance Charges LYR Long Integer LI_9U0 9 289 NFNCHYTD Number of Finance Charges YTD Long Integer LI_9U0 9 290 RTNGOWED Retainage Owed Currency DLR17_RBS0_STR$ 17 291 LSTCHNUM Last Check Number String Check_Number 20 292 LSTCHKDT Last Check Date Date DT 8 293 LSTCHAMT Last Check Amount Currency DLR17_RBS0_UTR$ 17 294 LSTINNUM Last Invoice Number String STR20 20 295 LSTINVAM Last Invoice Amount Currency DLR17_RBS0_UTR$ 17 296 LSTPURDT Last Purchase Date Date DT 8 297 FSTPURDT First Purchase Date Date DT 8 298 CURUNPBN Current Unapplied Payment Balance Currency DLR17_RBS0_UTR$ 17 299 UNPDFNCH Unpaid Finance Charges Currency DLR17_RBS0_UTR$ 17 300 DYCHTCLR Days Checks To Clear Integer INT3_U0 3 301 AVGDTPYR Average Days To Pay - Year Integer INT3_U0 3 302 AVDTPLIF Average Days To Pay - Life Integer INT3_U0 3 303 CUSTNAME Customer Name String STR64_Customer_Name 64 304 CUSTCLAS Customer Class String STR15_Customer_Class 15 305 CPRCSTNM Corporate Customer Number String STR15_RM_Customer_Number 15 306 CNTCPRSN Contact Person String STR60 60 307 STMTNAME Statement Name String STR64 64 308 SHRTNAME Short Name String STR15 15 309 ADRSCODE Address Code String STR15_Address_Code 15 310 STADDRCD Statement Address Code String STR15_LBAU 15 311 SLPRSNID Salesperson ID String STR15_Salesperson_ID 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].SLPRSNID AS 'SmartList Purchasing Line Items-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['SmartList Purchasing Line Items'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID312 CRLMTTYP Credit Limit Type Integer GB_Amt_Type 0 313 CRLMTAMT Credit Limit Amount Currency DLR17_RBS0_UTR$ 17 314 CRLMTPER Credit Limit Period Integer DDL 0 315 CRLMTPAM Credit Limit Period Amount Currency DLR17_RBS0_UTR$ 17 316 CUSTDISC Customer Discount Integer INT5_%2 5 317 FNCHATYP Finance Charge Amt Type Integer GB_Amt_Type 0 318 FNCHPCNT Finance Charge Percent Integer INT5_%2 5 319 FINCHDLR Finance Charge Dollar Currency DLR17_RBS0_UTR$ 17 320 MXWOFTYP Maximum Writeoff Type Integer GP_Max_Writeoff 0 321 MXWROFAM Max Writeoff Amount Currency DLR17_RBS0_UTR$ 17 322 TAXEXMT1 Tax Exempt 1 String STR25 25 323 TAXEXMT2 Tax Exempt 2 String STR25 25 324 BALNCTYP Balance Type Integer GB_Bal_Type 0 325 STMTCYCL Statement Cycle Integer DDL_Stmt_Cycle 0 326 BANKNAME Bank Name String STR30 30 327 BNKBRNCH Bank Branch String STR20 20 328 SALSTERR Sales Territory String STR15_Sales_Territory 15 Key to the Sales Territory Master File (RM00303).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].SALSTERR AS 'SmartList Purchasing Line Items-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['SmartList Purchasing Line Items'].SALSTERR = ['Sales Territory Master File'].SALSTERR329 DEFCACTY Default Cash Account Type Integer GB 0 330 RMCSHACC RM Cash Account Index Long Integer LI_14 14 331 RMARACC RM AR Account Index Long Integer LI_14 14 332 RMSLSACC RM Sales Account Index Long Integer LI_14 14 333 RMIVACC RM IV Account Index Long Integer LI_14 14 334 RMCOSACC RM Cost Of Sales Account Index Long Integer LI_14 14 335 RMTAKACC RM Discounts Taken Account Index Long Integer LI_14 14 336 RMAVACC RM Discounts Avail Account Index Long Integer LI_14 14 337 RMFCGACC RM Finance Charge Account Index Long Integer LI_14 14 338 RMWRACC RM Writeoff Account Index Long Integer LI_14 14 339 FRSTINDT First Invoice Date Date DT_Date 6 340 INACTIVE Inactive Boolean CB_Inactive 0 341 CRCARDID Credit Card ID String STR15 15 342 CRCRDNUM Credit Card Number String STR20 20 343 CCRDXPDT Credit Card Exp Date Date DT_Date 6 344 Revalue_Customer Revalue Customer Boolean CB Revalue Customer 0 345 FINCHID Finance Charge ID String STR15_Charge_ID 15 346 GOVCRPID Governmental Corporate ID String STR30_Gov_Corp_ID 30 347 GOVINDID Governmental Individual ID String STR30_Gov_Indiv_ID 30 348 TNSFCLIF Total Amount Of NSF Checks Life Currency DLR19_RBS0_STR$ 19 349 NONSFLIF Number Of NSF Checks Life Long Integer LI6_U0 6 350 CUSTBLNC Customer Balance Currency DLR19_RBS0_STR$ 19 351 AGPERAMT_1 Aging Period Amounts[1] Currency DLR17_RBSO_STR$ 17 352 AGPERAMT_2 Aging Period Amounts[2] Currency DLR17_RBSO_STR$ 17 353 AGPERAMT_3 Aging Period Amounts[3] Currency DLR17_RBSO_STR$ 17 354 AGPERAMT_4 Aging Period Amounts[4] Currency DLR17_RBSO_STR$ 17 355 AGPERAMT_5 Aging Period Amounts[5] Currency DLR17_RBSO_STR$ 17 356 AGPERAMT_6 Aging Period Amounts[6] Currency DLR17_RBSO_STR$ 17 357 AGPERAMT_7 Aging Period Amounts[7] Currency DLR17_RBSO_STR$ 17 358 LASTAGED Last Aged Date DATE 6 359 LSTNSFCD Last NSF Check Date Date DT_Date 6 360 LPYMTAMT Last Payment Amount Currency DLR17_RBS0_STR$ 17 361 LASTPYDT Last Payment Date Date DT_Date 6 362 LSTTRXDT Last Transaction Date Date DT_Date 6 363 LSTTRXAM Last Transaction Amount Currency DLR17_RBS0_STR$ 17 364 LSTFCHAM Last Finance Charge Amount Currency DLR19_RBS0_STR$ 19 365 UPFCHYTD Unpaid Finance Charges YTD Currency DLR17_RBS0_UTR$ 17 366 NUMADTPL Number ADTP Documents - Life Long Integer Long_10U 10 367 NUMADTPR Number ADTP Documents - LYR Long Integer Long_10U 10 368 NUMADTPY Number ADTP Documents - Year Long Integer Long_10U 10 369 TDTKNLTD Total Discounts Taken LTD Currency DLR19_RBS0_STR$ 19 370 TDTKNLYR Total Discounts Taken LYR Currency DLR19_RBS0_STR$ 19 371 TDTKNYTD Total Discounts Taken YTD Currency DLR19_RBS0_STR$ 19 372 TDISAYTD Total Discounts Available YTD Currency DLR19_RBS0_STR$ 19 373 RETAINAG Retainage Currency DLR19_RBS0_STR$ 19 374 TNSFCYTD Total Amount Of NSF Checks YTD Currency DLR19_RBS0_STR$ 19 375 NONSFYTD Number Of NSF Checks YTD Long Integer LI6_U0 6 376 UNPSTDSA Unposted Sales Amount Currency DLR19_RBS0_UTR$ 19 377 UNPSTDCA Unposted Cash Amount Currency DLR19_RBS0_UTR$ 19 378 UNPSTOSA Unposted Other Sales Amount Currency DLR19_RBS0_UTR$ 19 379 UNPSTOCA Unposted Other Cash Amount Currency DLR19_RBS0_UTR$ 19 380 NCSCHPMT Non Current Scheduled Payments Currency DLR19_RBS0_STR$ 19 381 TTLSLLTD Total Sales LTD Currency DLR19_RBS0_STR$ 19 382 TTLSLLYR Total Sales LYR Currency DLR19_RBS0_STR$ 19 383 TTLSLYTD Total Sales YTD Currency DLR19_RBS0_STR$ 19 384 TCOSTLTD Total Costs LTD Currency DLR19_RBS0_STR$ 19 385 TCOSTLYR Total Costs LYR Currency DLR19_RBS0_STR$ 19 386 TCOSTYTD Total Costs YTD Currency DLR19_RBS0_STR$ 19 387 TCSHRLTD Total Cash Received LTD Currency DLR19_RBS0_STR$ 19 388 TCSHRLYR Total Cash Received LYR Currency DLR19_RBS0_STR$ 19 389 TCSHRYTD Total Cash Received YTD Currency DLR19_RBS0_STR$ 19 390 TFNCHLTD Total Finance Charges LTD Currency DLR19_RBS0_STR$ 19 391 TFNCHLYR Total Finance Charges LYR Currency DLR19_RBS0_STR$ 19 392 TFNCHYTD Total Finance Charges YTD Currency DLR19_RBS0_STR$ 19 393 FNCHCYTD Finance Charges CYTD Currency DLR19_RBS0_STR$ 19 394 FNCHLYRC Finance Charges LYR Calendar Currency DLR19_RBS0_STR$ 19 395 TBDDTLYR Total Bad Deb LYR Currency DLR19_RBS0_STR$ 19 396 TBDDTLTD Total Bad Debt LTD Currency DLR19_RBS0_STR$ 19 397 TBDDTYTD Total Bad Debt YTD Currency DLR19_RBS0_STR$ 19 398 TWVFCLTD Total Waived FC LTD Currency DLR19_RBS0_STR$ 19 399 TWVFCLYR Total Waived FC LYR Currency DLR19_RBS0_STR$ 19 400 TWVFCYTD Total Waived FC YTD Currency DLR19_RBS0_STR$ 19 401 TWROFLTD Total Writeoffs LTD Currency DLR19_RBS0_STR$ 19 402 TWROFLYR Total Writeoffs LYR Currency DLR19_RBS0_STR$ 19 403 TWROFYTD Total Writeoffs YTD Currency DLR19_RBS0_STR$ 19 404 TTLINLTD Total # Invoices LTD Long Integer LI6_U0 6 405 TTLINLYR Total # Invoices LYR Long Integer LI6_U0 6 406 TTLINYTD Total # Invoices YTD Long Integer LI6_U0 6 407 TTLFCLTD Total # FC LTD Long Integer LI6_U0 6 408 TTLFCLYR Total # FC LYR Long Integer LI6_U0 6 409 TTLFCYTD Total # FC YTD Long Integer LI6_U0 6 410 HIBALLTD High Balance LTD Currency DLR19_RBSO_STR$ 19 411 HIBALLYR High Balance LYR Currency DLR19_RBSO_STR$ 19 412 HIBALYTD High Balance YTD Currency DLR19_RBSO_STR$ 19 413 LASTSTDT Last Statement Date Date DATE 6 414 LSTSTAMT Last Statement Amount Currency DLR17_RBS0_STR$ 17 415 DEPRECV Deposits Received Currency DLR19_RBS0_STR$ 19 416 ABCCODE ABC Code Integer DDL_ABC_Code 0 417 CGSINFLX COGS Inflation Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].CGSINFLX AS 'SmartList Purchasing Line Items-COGS Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].CGSINFLX = ['Account Index Master'].ACTINDX418 CGSMCIDX COGS Monetary Correction Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].CGSMCIDX AS 'SmartList Purchasing Line Items-COGS Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].CGSMCIDX = ['Account Index Master'].ACTINDX419 IVINFIDX Inventory Inflation Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].IVINFIDX AS 'SmartList Purchasing Line Items-Inventory Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].IVINFIDX = ['Account Index Master'].ACTINDX420 INVMCIDX Inventory Monetary Correction Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].INVMCIDX AS 'SmartList Purchasing Line Items-Inventory Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].INVMCIDX = ['Account Index Master'].ACTINDX421 ITEMCODE Item Code String STR15 15 422 KTACCTSR Kit COGS Account Source Integer GB 0 423 LASTGENSN Last Generated Serial Number String STR20_LBAU 20 424 PriceGroup Price Group String STR10_LBAU 10 425 PRICMTHD Price Method Integer DDL_Price_Method 0 426 PINFLIDX Purch Inflation Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PINFLIDX AS 'SmartList Purchasing Line Items-Purch Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PINFLIDX = ['Account Index Master'].ACTINDX427 PURMCIDX Purch Monetary Correction Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].PURMCIDX AS 'SmartList Purchasing Line Items-Purch Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].PURMCIDX = ['Account Index Master'].ACTINDX428 PRCHSUOM Purchasing U Of M String U_Of_M 8 429 SELNGUOM Selling U Of M String U_Of_M 8 430 TCC Tax Commodity Code String STR30_VAT 30 431 UPPVIDX Unrealized Purchase Price Variance Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].UPPVIDX AS 'SmartList Purchasing Line Items-Unrealized Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Purchasing Line Items'].UPPVIDX = ['Account Index Master'].ACTINDX432 DISGRPER Discount Grace Period Integer INT2_U0 2 433 DOCFMTID Document Format ID String STR15_LBU 15 434 DUEGRPER Due Date Grace Period Integer INT2_U0 2 435 PHONE3 Phone 3 String Phone_Number3 14 436 TaxInvRecvd Tax Invoice Received Boolean CB_Tax_Invoice_Received 0 437 Withholding_LIFE Withholding LIFE Currency DLR19_RBS0_STR$ 19 438 WITHLYR Withholding LYR Currency DLR19_RBS0_STR$ 19 439 WITHYTD Withholding YTD Currency DLR19_RBS0_STR$ 19 440 Change_Order_Flag Change Order Flag Integer INT 0 441 PO_Field_Changes PO Field Changes Long Integer ML_POP_PO_Field_Changes 0 442 PO_Status_Orig PO Status Orig Integer DDL_PO_Status 0 443 Revision_Number Revision Number Integer INT4 4 444 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].LOCNCODE AS 'SmartList Purchasing Line Items-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['SmartList Purchasing Line Items'].LOCNCODE = ['Site Setup'].LOCNCODE445 RELEASEBYDATE Release By Date Date DATE_L 0 446 Released_Date Released Date Date DATE_L 0 447 UPSZONE1 ASI_UPS_Zone String STR3 3 448 SHIPMTHD1 ASI_Shipping_Method String STR15_Shipping_Method 15 449 TAXSCHID1 ASI_Tax_Schedule_ID String STR15_Tax_Schedule_ID 15 450 ADDRESS11 ASI_Address_1 String STR60 60 451 ADDRESS21 ASI_Address_2 String STR60 60 452 ADDRESS31 ASI_Address_3 String STR60 60 453 CITY1 ASI_City String STR35 35 454 STATE1 ASI_State String STR30_State 29 455 COUNTRY1 ASI_Country String STR60 60 456 ZIP1 ASI_Zip String STR10 10 457 PHONE11 ASI_Phone_1 String Phone_Number 14 458 PHONE21 ASI_Phone_2 String Phone_Number 14 459 FAX1 ASI_Fax String STR14_FAX 14 460 PRBTADCD1 ASI_Primary_Billto_Address_Code String STR15_LBAU 15 461 PRSTADCD1 ASI_Primary_Shipto_Address_Code String STR15_LBAU 15 462 CHEKBKID1 ASI_Checkbook_ID String STR15_Checkbook_ID 15 463 PYMTRMID1 ASI_Payment_Terms_ID String STR20_Payment_Terms_ID 20 464 CURNCYID1 ASI_Currency_ID String STR15_Currency_ID 15 465 RATETPID1 ASI_Rate_Type_ID String STR15_Rate_Type_ID 15 466 ASI_Minimum_Payment_Type ASI_Minimum_Payment_Type Integer ASI_Minimum_Payment_Type 0 467 MINPYDLR1 ASI_Minimum_Payment_Dollar Currency DLR17_RBS0_UTR$ 17 468 MINPYPCT1 ASI_Minimum_Payment_Percent Integer INT5_%2 5 469 COMMENT11 ASI_Comment1 String STR30 30 470 COMMENT21 ASI_Comment2 String STR30 30 471 USERDEF11 ASI_User_Defined_1 String STR20 20 472 USERDEF21 ASI_User_Defined_2 String STR20 20 473 TXRGNNUM1 ASI_Tax_Registration_Number String STR25 25 474 HOLD1 ASI_Hold Boolean CB_Hold 0 475 KPDSTHST1 ASI_Keep_Distribution_History Boolean CB_Keep_Dist_History 0 476 KPCALHST1 ASI_Keep_Calendar_History Boolean CB_Keep_Calendar_History 0 477 KPERHIST1 ASI_Keep_Period_History Boolean CB_Keep_Period_History 0 478 KPTRXHST1 ASI_Keep_Trx_History Boolean CB_Keep_Trx_History 0 479 NOTEINDX1 ASI_Note_Index Currency DLR14 14 480 CREATDDT1 ASI_Created_Date Date DT 8 481 MODIFDT1 ASI_Modified_Date Date DT 8 482 FRSTINDT1 ASI_First_Invoice_Date Date DT_Date 6 483 AVDTPLIF1 ASI_Average_Days_To_Pay_Life Integer INT3_U0 3 484 AVDTPLYR1 ASI_Average_Days_to_Pay_LYR Integer INT3_U0 3 485 AVGDTPYR1 ASI_Average_Days_To_Pay_Year Integer INT3_U0 3 486 WROFSLIF1 ASI_Write_Offs_LIFE Currency DLR19_RBS0_STR$ 19 487 WROFSLYR1 ASI_Write_Offs_LYR Currency DLR19_RBS0_STR$ 19 488 WROFSYTD1 ASI_Write_Offs_YTD Currency DLR19_RBS0_STR$ 19 489 ONORDAMT1 ASI_On_Order_Amount Currency DLR19_RBS0_UTR$ 19 490 ASI_Post_Results_To ASI_Post_Results_To Integer ASI_Post_Results_To 0 491 DISGRPER1 ASI_Discount_Grace_Period Integer INT2_U0 2 492 DOCFMTID1 ASI_Document_Format_ID String STR15_LBU 15 493 DUEGRPER1 ASI_Due_Date_Grace_Period Integer INT2_U0 2 494 PHONE31 ASI_Phone_3 String Phone_Number 14 495 ITEMDESC1 ASI_Item_Description String STR50 50 496 NOTEINDX11 ASI_Note_Index2 Currency DLR14 14 497 DECPLQTY1 ASI_Decimal_Places_QTYS Integer DDL_Decimal_Places_QTYS 0 498 DECPLCUR1 ASI_Decimal_Places_Currency Integer DDL_Decimal_Places_Dollars 0 499 ITMTRKOP1 ASI_Item_Tracking_Option Integer DDL_Track 0 500 VCTNMTHD1 ASI_Valuation_Method Integer DDL_Valuation_Method 0 501 MODIFDT11 ASI_Modified_Date2 Date DT 8 502 CREATDDT11 ASI_Created_Date2 Date DT 8 503 PRCLEVEL1 ASI_PriceLevel String STR10_LBAU 10 504 PRMDATE1 ASI_Promised_Date Date DATE_L 0 505 PRMSHPDTE1 ASI_Promised_Ship_Date Date DATE_L 0 506 LOCNCODE1 ASI_Location_Code String STR10_Location_Code 10 507 COMMNTID1 ASI_Comment_ID String STR15_Comment_ID 15 508 CURNCYID11 ASI_Currency_ID2 String STR15_Currency_ID 15 509 ASI_Currency_Index ASI_Currency_Index Integer INT3 3 510 XCHGRATE1 ASI_Exchange_Rate Currency (Variable) DLR14_Exchange_Rate 14 511 RATECALC1 ASI_Rate_Calc_Method Integer INT 0 512 DENXRATE1 ASI_Denomination_Exchange_Rate Currency (Variable) DLR14_Exchange_Rate 14 513 Change_Order_Flag1 ASI_Change_Order_Flag Boolean Boolean 0 514 VENDNAME1 ASI_Vendor_Name String STR64_Vendor_Name 64 515 VADCDPAD1 ASI_Vendor_Address_Code_Purchase_Address String STR15_Address_Code 15 516 ADDRESS111 ASI_Address_12 String STR60 60 517 ADDRESS211 ASI_Address_22 String STR60 60 518 ADDRESS311 ASI_Address_32 String STR60 60 519 CITY11 ASI_City2 String STR35 35 520 STATE11 ASI_State2 String STR30_State 29 521 ZIPCODE1 ASI_Zip_Code String STR10 10 522 COUNTRY11 ASI_Country2 String STR60 60 523 PHNUMBR11 ASI_Phone_Number_1 String Phone_Number 14 524 PHNUMBR21 ASI_Phone_Number_2 String Phone_Number 14 525 FAXNUMBR1 ASI_Fax_Number String STR14_FAX 14 526 SHIPMTHD11 ASI_Shipping_Method2 String STR15_Shipping_Method 15 527 CURNCYID111 ASI_Currency_ID3 String STR15_Currency_ID 15 528 TXRGNNUM11 ASI_Tax_Registration_Number2 String STR25 25 529 MINORDER1 ASI_Minimum_Order Currency DLR17_$U2 17 530 PYMTRMID11 ASI_Payment_Terms_ID2 String STR20_Payment_Terms_ID 20 531 COMMENT111 ASI_Comment12 String STR30 30 532 COMMENT211 ASI_Comment22 String STR30 30 533 KPCALHST11 ASI_Keep_Calendar_History2 Boolean CB_Keep_Calendar_History 0 534 KPERHIST11 ASI_Keep_Period_History2 Boolean CB_Keep_Period_History 0 535 KPTRXHST11 ASI_Keep_Trx_History2 Boolean CB_Keep_Trx_History 0 536 HOLD11 ASI_Hold2 Boolean CB_Hold 0 537 PURPVIDX1 ASI_Purchase_Price_Variance_Index Long Integer LI_14 14 538 NOTEINDX111 ASI_Note_Index3 Currency DLR14 14 539 MODIFDT111 ASI_Modified_Date3 Date DT 8 540 CREATDDT111 ASI_Created_Date3 Date DT 8 541 RATETPID11 ASI_Rate_Type_ID2 String STR15_Rate_Type_ID 15 542 FREEONBOARD1 ASI_Free_On_Board Integer DDL_Free_On_Board 0 543 DISGRPER11 ASI_Discount_Grace_Period2 Integer INT2_U0 2 544 DUEGRPER11 ASI_Due_Date_Grace_Period2 Integer INT2_U0 2 545 GOVCRPID1 ASI_Governmental_Corporate_ID String STR30_Gov_Corp_ID 30 546 GOVINDID1 ASI_Governmental_Individual_ID String STR30_Gov_Indiv_ID 30 547 PHONE311 ASI_Phone_32 String Phone_Number 14 548 ONORDAMT11 ASI_On_Order_Amount2 Currency DLR19_RBS0_UTR$ 19 549 ASI_Required_Date ASI_Required_Date Date DATE_L 0 550 LOCNCODE11 ASI_Location_Code2 String STR10_Location_Code 10 551 TRXSORCE TRX Source String STR13 13 552 Purchase_IV_Item_Taxable Purchase IV Item Taxable Integer DDL_Purchase_Tax_Options 0 553 Purchase_Item_Tax_Schedu Purchase Item Tax Schedule ID String STR15_LBAU 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].Purchase_Item_Tax_Schedu AS 'SmartList Purchasing Line Items-Purchase Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Purchasing Line Items'].Purchase_Item_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID554 Purchase_Site_Tax_Schedu Purchase Site Tax Schedule ID String STR15_LBAU 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['SmartList Purchasing Line Items'].Purchase_Site_Tax_Schedu AS 'SmartList Purchasing Line Items-Purchase Site Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP21 AS ['SmartList Purchasing Line Items']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Purchasing Line Items'].Purchase_Site_Tax_Schedu = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID555 BSIVCTTL Based On Invoice Total Boolean YN 0 556 TAXAMNT1 ASI_Tax_Amount Currency DLR17_RBS0_UTR$ 17 557 ORTAXAMT1 ASI_Originating_Tax_Amount Currency DLR17_RBS0_UTR$ 17 558 Landed_Cost_Group_ID Landed Cost Group ID String STR15_LBAU 15 559 PLNNDSPPLID Planned Supply ID Integer INT 0 560 ASISHIPMTHD3 ASI_Shipping_Method3 String STR15_Shipping_Method 15 561 ORIGPRMDATE Original Promised Date Date DT 8 562 FSTRCPTDT First Receipt Date Date DT 8 563 LSTRCPTDT Last Receipt Date Date DT 8 564 CNTRLEXTQTY Control Line Ext Qty Currency DLR17_QTY_RBS0_UTR 17 565 CNTRLEXTCOST Control Line Ext Cost Currency DLR17_RBS0_UTR$ 17 566 REMAINEXTQTY Remaining Ext Qty Currency DLR17_QTY_RBS0_UTR 17 567 ASI_Address_Code ASI_Address_Code String STR15_Address_Code 15 568 CMPNYNAM1 ASI_Company_Name String STR64_Company_Name 64 569 CONTACT1 ASI_Contact String STR60 60 570 ADDRESS1111 ASI_Address_13 String STR60 60 571 ADDRESS2111 ASI_Address_23 String STR60 60 572 ADDRESS3111 ASI_Address_33 String STR60 60 573 CITY3 ASI_City3 String STR35 35 574 STATE3 ASI_State3 String STR30_State 29 575 ZIP3 ASI_Zip3 String STR10 10 576 COUNTRY3 ASI_Country3 String STR60 60 577 PHONE1111 ASI_Phone_13 String Phone_Number 14 578 PHONE2111 ASI_Phone_23 String Phone_Number 14 579 PHONE3111 ASI_Phone_33 String Phone_Number 14 580 FAX3 ASI_Fax3 String STR14_FAX 14 581 ADDRSOURCE Address Source Integer INT1 1 582 PURCHSITETXSCHSRC Purchase Site Tax Schedule Source Integer INT1 1 583 UMSCHDSC U Of M Schedule Description String STR30 30 584 QTYSHPPD QTY Shipped Currency DLR17_QTY_RBS0_UTR 17 585 QTYINVCD QTY Invoiced Currency DLR17_QTY_RBS0_UTR 17 586 QTYREJ QTY Rejected Currency DLR17_QTY_RBS0_UTR 17 587 QTYMATCH QTY Matched Currency DLR17_QTY_RBS0_UTR 17 588 ProjNum Project Number String STR15_LBAU 15 589 CostCatID Cost Category ID String STR15_LBAU 15 590 Total_Landed_Cost_Amount Total Landed Cost Amount Currency DLR17_RBS0_UTR$ 17 591 QTYINVRESERVE QTY Invoice Reserve Currency DLR17_QTY_RBS0_UTR 17 592 QTYRESERVED QTY Reserved Currency DLR17_QTY_RBS0_UTR 17