Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP20
Product: SmartList (1493)
Series:
Display Name: ASI SOP Line Item SmartList
Physical Name: ASIEXP20
Technical Name: ASI_SOP_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 ASI_Favorite_Sequence ASI_Favorite_Sequence Long Integer ASI_LI_10_RU 10 3 SOPTYPE SOP Type Integer DDL_SOP_Type 0 4 SOPNUMBE SOP Number String STR20_SOP_Number 17 5 LNITMSEQ Line Item Sequence Long Integer LI_Sequence_Number 10 6 CMPNTSEQ Component Sequence Long Integer LI_Sequence_Number 10 7 ASI_Document_Status ASI_Document_Status Integer INT 0 8 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].ITEMNMBR AS 'ASI SOP Line Item SmartList-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
IV00101 AS ['Item Master']
ON
['ASI SOP Line Item SmartList'].ITEMNMBR = ['Item Master'].ITEMNMBR9 ITEMDESC Item Description String STR100 100 10 NONINVEN Non IV Integer INT1 1 11 DROPSHIP Drop Ship Integer INT2 2 12 UOFM U Of M String U_Of_M 8 13 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].LOCNCODE AS 'ASI SOP Line Item SmartList-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['ASI SOP Line Item SmartList'].LOCNCODE = ['Site Setup'].LOCNCODE14 UNITCOST Unit Cost Currency DLR17_RBS0_UTR$ 17 15 ORUNTCST Originating Unit Cost Currency DLR17_RBS0_UTR$ 17 16 UNITPRCE Unit Price Currency DLR17_RBS0_STR$ 17 17 ORUNTPRC Originating Unit Price Currency DLR17_RBS0_STR$ 17 18 XTNDPRCE Extended Price Currency DLR17_RBS0_STR$ 17 19 OXTNDPRC Originating Extended Price Currency DLR17_RBS0_STR$ 17 20 REMPRICE Remaining Price Currency DLR17_RBS0_UTR$ 17 21 OREPRICE Originating Remaining Price Currency DLR17_RBS0_UTR$ 17 22 EXTDCOST Extended Cost Currency DLR17_RBS0_UTR$ 17 23 OREXTCST Originating Extended Cost Currency DLR17_RBS0_UTR$ 17 24 MRKDNAMT Markdown Amount Currency DLR17_RBS0_UTR$ 17 25 ORMRKDAM Originating Markdown Amount Currency DLR17_RBS0_UTR$ 17 26 MRKDNPCT Markdown Percent Integer INT5_%2 5 27 MRKDNTYP Markdown Type Integer GB 0 28 INVINDX Inventory Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].INVINDX AS 'ASI SOP Line Item SmartList-Inventory Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].INVINDX = ['Account Index Master'].ACTINDX29 CSLSINDX Cost Of Sales Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CSLSINDX AS 'ASI SOP Line Item SmartList-Cost Of Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].CSLSINDX = ['Account Index Master'].ACTINDX30 SLSINDX Sales Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].SLSINDX AS 'ASI SOP Line Item SmartList-Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].SLSINDX = ['Account Index Master'].ACTINDX31 MKDNINDX Markdown Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].MKDNINDX AS 'ASI SOP Line Item SmartList-Markdown Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].MKDNINDX = ['Account Index Master'].ACTINDX32 RTNSINDX Returns Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].RTNSINDX AS 'ASI SOP Line Item SmartList-Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].RTNSINDX = ['Account Index Master'].ACTINDX33 INUSINDX In Use Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].INUSINDX AS 'ASI SOP Line Item SmartList-In Use Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].INUSINDX = ['Account Index Master'].ACTINDX34 INSRINDX In Service Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].INSRINDX AS 'ASI SOP Line Item SmartList-In Service Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].INSRINDX = ['Account Index Master'].ACTINDX35 DMGDINDX Damaged Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].DMGDINDX AS 'ASI SOP Line Item SmartList-Damaged Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].DMGDINDX = ['Account Index Master'].ACTINDX36 ITMTSHID Item Tax Schedule ID String STR15_LBAU 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].ITMTSHID AS 'ASI SOP Line Item SmartList-Item Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['ASI SOP Line Item SmartList'].ITMTSHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID37 IVITMTXB IV Item Taxable Integer DDL_Tax_Options 0 38 BKTSLSAM Backout Sales Amount Currency DLR19_RBS0_UTR$ 19 39 ORBKTSLS Originating Backout Sales Amount Currency DLR19_RBS0_UTR$ 19 40 TAXAMNT Tax Amount Currency DLR17_RBS0_UTR$ 17 41 ORTAXAMT Originating Tax Amount Currency DLR17_RBS0_UTR$ 17 42 TXBTXAMT Taxable Tax Amount Currency DLR19_RBSO_UTR$ 19 43 OTAXTAMT Originating Taxable Tax Amount Currency DLR17_RBS0_UTR$ 17 44 BSIVCTTL Based On Invoice Total Boolean YN 0 45 TRDISAMT Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 46 ORTDISAM Originating Trade Discount Amount Currency DLR17_RBS0_UTR$ 17 47 DISCSALE Discount Available Sales Currency DLR17_RBS0_UTR$ 17 48 ORDAVSLS Originating Discount Available Sales Currency DLR17_RBS0_UTR$ 17 49 QUANTITY QTY Currency DLR17_QTY_RBS0_STR 17 50 ATYALLOC QTY Allocated Currency DLR17_QTY_RBS0_UTR 17 51 QTYINSVC QTY In Service Currency DLR17_QTY_RBS0_UTR 17 52 QTYINUSE QTY In Use Currency DLR17_QTY_RBS0_UTR 17 53 QTYDMGED QTY Damaged Currency DLR17_QTY_RBS0_UTR 17 54 QTYRTRND QTY Returned Currency DLR17_QTY_RBS0_UTR 17 55 QTYONHND QTY On Hand Currency DLR17_QTY_RBS0_STR 17 56 QTYCANCE QTY Canceled Currency DLR17_QTY_RBS0_UTR 17 57 QTYCANOT QTY Canceled Other Currency DLR17_QTY_RBS0_UTR 17 58 QTYORDER QTY Ordered Currency DLR17_QTY_RBS0_UTR 17 59 QTYPRBAC QTY Prev Back Ordered Currency DLR17_QTY_RBS0_UTR 17 60 QTYPRBOO QTY Prev BO On Order Currency DLR17_QTY_RBS0_UTR 17 61 QTYPRINV QTY Prev Invoiced Currency DLR17_QTY_RBS0_UTR 17 62 QTYPRORD QTY Prev Ordered Currency DLR17_QTY_RBS0_UTR 17 63 QTYREMAI QTY Remaining Currency DLR17_QTY_RBS0_UTR 17 64 QTYREMBO QTY Remaining On BO Currency DLR17_QTY_RBS0_UTR 17 65 QTYTBAOR QTY To Back Order Currency DLR17_QTY_RBS0_UTR 17 66 QTYTOINV QTY To Invoice Currency DLR17_QTY_RBS0_UTR 17 67 QTYTORDR QTY To Order Currency DLR17_QTY_RBS0_UTR 17 68 QTYFULFI QTY Fulfilled Currency DLR17_QTY_RBS0_UTR 17 69 QTYSLCTD QTY Selected Currency DLR17_QTY_RBS0_UTR 17 70 QTYBSUOM QTY In Base U Of M Currency DLR17_QTY_RBS0_STR 17 71 EXTQTYAL Existing Qty Available Currency DLR17_RBS0_UTR$ 17 72 EXTQTYSEL Existing Qty Selected Currency DLR17_QTY_RBS0_STR 17 73 ReqShipDate Requested Ship Date Date DT 8 74 FUFILDAT Fulfillment Date Date DT 8 75 ACTLSHIP Actual Ship Date Date DT 8 76 SHIPMTHD Shipping Method String STR15_Shipping_Method 15 Key to the Shipping Methods Master (SY03000).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].SHIPMTHD AS 'ASI SOP Line Item SmartList-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['ASI SOP Line Item SmartList'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD77 SALSTERR Sales Territory String STR15_Sales_Territory 15 Key to the Sales Territory Master File (RM00303).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].SALSTERR AS 'ASI SOP Line Item SmartList-Sales Territory'
,['Sales Territory Master File'].SALSTERR AS 'Sales Territory Master File-Sales Territory'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
RM00303 AS ['Sales Territory Master File']
ON
['ASI SOP Line Item SmartList'].SALSTERR = ['Sales Territory Master File'].SALSTERR78 SLPRSNID Salesperson ID String STR15_Salesperson_ID 15 Key to the RM Salesperson Master (RM00301).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].SLPRSNID AS 'ASI SOP Line Item SmartList-Salesperson ID'
,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
RM00301 AS ['RM Salesperson Master']
ON
['ASI SOP Line Item SmartList'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID79 PRCLEVEL PriceLevel String STR10_LBAU 10 80 COMMNTID Comment ID String STR15_Comment_ID 15 Key to the Comment Master (SY04200).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].COMMNTID AS 'ASI SOP Line Item SmartList-Comment ID'
,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
SY04200 AS ['Comment Master']
ON
['ASI SOP Line Item SmartList'].COMMNTID = ['Comment Master'].COMMNTID81 BRKFLD1 Break Field 1 Integer INT1 1 82 BRKFLD2 Break Field 2 Integer INT1 1 83 BRKFLD3 Break Field 3 Integer INT1 1 84 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CURRNIDX AS 'ASI SOP Line Item SmartList-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['ASI SOP Line Item SmartList'].CURRNIDX = ['Currency Setup'].CURRNIDX85 TRXSORCE TRX Source String STR13 13 86 SOPLNERR SOP LINE Errors Long Integer ML_SOP_LINE_Errors 0 87 PURCHSTAT Purchasing Status Integer DDL_PurchasingStatus 0 88 QTYONPO QTY On PO Currency DLR17_QTY_RBS0_UTR 17 89 QTYRECVD QTY Received Currency DLR17_QTY_RBS0_UTR 17 90 QTYPRVRECVD QTY Prev Received Currency DLR17_QTY_RBS0_UTR 17 91 ORIGTYPE Original Type Integer DDL_SOP_Type 0 92 DOCID Document ID String STR15_LBAU 15 93 DOCDATE Document Date Date DT 8 94 GLPOSTDT GL Posting Date Date DT 8 95 QUOTEDAT Quote Date Date DT 8 96 QUOEXPDA Quote Expiration Date Date DT 8 97 ORDRDATE Order Date Date DT 8 98 INVODATE Invoice Date Date DT 8 99 BACKDATE Back Order Date Date DT 8 100 RETUDATE Return Date Date DT 8 101 DISCDATE Discount Date Date DT 8 102 DUEDATE Due Date Date DT 8 103 REPTING Repeating Boolean CB_Repeating 0 104 TRXFREQU TRX Frequency Integer DDL_TRX_Frequency 0 105 TIMEREPD Times Repeated Integer INT4_U0 4 106 DYSTINCR Days to Increment Integer INT3_RB0_U 3 107 DTLSTREP Date Last Repeated Date DT 8 108 DSTBTCH1 Dest Batch 1 String STR15_LBAU 15 109 DSTBTCH2 Dest Batch 2 String STR15_LBAU 15 110 USDOCID1 Use Document ID 1 String STR15_LBAU 15 111 USDOCID2 Use Document ID 2 String STR15_LBAU 15 112 DISCFRGT Discount Available Freight Currency DLR17_RBS0_UTR$ 17 113 ORDAVFRT Originating Discount Available Freight Currency DLR17_RBS0_UTR$ 17 114 DISCMISC Discount Available Misc Currency DLR17_RBS0_UTR$ 17 115 ORDAVMSC Originating Discount Available Misc Currency DLR17_RBS0_UTR$ 17 116 DISAVAMT Discount Available Amount Currency DLR17_RBS0_UTR$ 17 117 ORDAVAMT Originating Discount Available Amount Currency DLR17_RBS0_UTR$ 17 118 DISCRTND Discount Returned Currency DLR17_RBS0_STR$ 17 119 ORDISRTD Originating Discount Returned Currency DLR17_RBS0_STR$ 17 120 DISTKNAM Discount Taken Amount Currency DLR17_RBS0_UTR$ 17 121 ORDISTKN Originating Discount Taken Amount Currency DLR17_RBS0_UTR$ 17 122 DSCPCTAM Discount Percent Amount Integer INT5_%2 5 123 DSCDLRAM Discount Dollar Amount Currency DLR11_RBS0_UTR$ 11 124 ORDATKN Originating Discount Available Taken Currency DLR17_RBS0_UTR$ 17 125 PYMTRMID Payment Terms ID String STR20_Payment_Terms_ID 20 Key to the Payment Terms Master (SY03300).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].PYMTRMID AS 'ASI SOP Line Item SmartList-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['ASI SOP Line Item SmartList'].PYMTRMID = ['Payment Terms Master'].PYMTRMID126 BCHSOURC Batch Source String STR15 15 127 BACHNUMB Batch Number String STR15_LBAU 15 128 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CUSTNMBR AS 'ASI SOP Line Item SmartList-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['ASI SOP Line Item SmartList'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR129 CUSTNAME Customer Name String STR64_Customer_Name 64 130 CSTPONBR Customer PO Number String STR20_Document_Number 20 131 PROSPECT Prospect Integer INT1 1 132 MSTRNUMB Master Number Long Integer LI_MasterNumber 9 133 PCKSLPNO Packing Slip Number String STR20_IVC_Document_Number 17 134 PICTICNU Picking Ticket Number String STR20_SOP_Number 17 135 PRBTADCD Primary Billto Address Code String STR15_LBAU 15 136 PRSTADCD Primary Shipto Address Code String STR15_LBAU 15 137 CNTCPRSN Contact Person String STR60 60 138 ShipToName ShipToName String STR64_Customer_Name 64 139 ADDRESS1 Address 1 String STR60 60 140 ADDRESS2 Address 2 String STR60 60 141 ADDRESS3 Address 3 String STR60 60 142 CITY City String STR35 35 143 STATE State String STR30_State 29 144 ZIPCODE Zip Code String STR10 10 145 COUNTRY Country String STR60 60 146 PHNUMBR1 Phone Number 1 String Phone_Number 14 147 PHNUMBR2 Phone Number 2 String Phone_Number 14 148 FAXNUMBR Fax Number String STR14_FAX 14 149 COMAPPTO Commission Applied To Integer GB 0 150 COMMAMNT Commission Amount Currency DLR17_RBS0_STR$ 17 151 OCOMMAMT Originating Commission Amount Currency DLR17_RBSO_STR$ 17 152 CMMSLAMT Commission Sale Amount Currency DLR17_RBS0_STR$ 17 153 ORCOSAMT Originating Commission Sales Amount Currency DLR17_RBS0_STR$ 17 154 NCOMAMNT Non-Commissioned Amount Currency DLR19_RBS0_STR$ 19 155 ORNCMAMT Originating Non-Commissioned Amount Currency DLR19_RBS0_STR$ 19 156 TRDISPCT Trade Discount Percent Integer INT4_%2 4 157 SUBTOTAL Subtotal Currency DLR17_RBS0_STR$ 17 158 ORSUBTOT Originating Subtotal Currency DLR17_RBS0_STR$ 17 159 REMSUBTO Remaining Subtotal Currency DLR17_RBS0_UTR$ 17 160 OREMSUBT Originating Remaining Subtotal Currency DLR17_RBS0_UTR$ 17 161 FRTAMNT Freight Amount Currency DLR17_RBS0_UTR$ 17 162 ORFRTAMT Originating Freight Amount Currency DLR17_RBS0_UTR$ 17 163 MISCAMNT Misc Amount Currency DLR17_RBS0_UTR$ 17 164 ORMISCAMT Originating Misc Amount Currency DLR19_RBSO_UTR$ 19 165 TXENGCLD Tax Engine Called Boolean YN 0 166 TAXEXMT1 Tax Exempt 1 String STR25 25 167 TAXEXMT2 Tax Exempt 2 String STR25 25 168 TXRGNNUM Tax Registration Number String STR25 25 169 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
['ASI SOP Line Item SmartList'].TAXSCHID AS 'ASI SOP Line Item SmartList-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['ASI SOP Line Item SmartList'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID170 TXSCHSRC Tax Schedule Source Integer INT1 1 171 FRTSCHID Freight Schedule ID String STR15_LBAU 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].FRTSCHID AS 'ASI SOP Line Item SmartList-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['ASI SOP Line Item SmartList'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID172 FRTTXAMT Freight Tax Amount Currency DLR19_RBSO_UTR$ 19 173 ORFRTTAX Originating Freight Tax Amount Currency DLR19_RBSO_UTR$ 19 174 FRGTTXBL Freight Taxable Integer DDL_Tax_Options 0 175 MSCSCHID Misc Schedule ID String STR15_LBAU 15 Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].MSCSCHID AS 'ASI SOP Line Item SmartList-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['ASI SOP Line Item SmartList'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID176 MSCTXAMT Misc Tax Amount Currency DLR19_RBSO_UTR$ 19 177 ORMSCTAX Originating Misc Tax Amount Currency DLR19_RBSO_UTR$ 19 178 MISCTXBL Misc Taxable Integer DDL_Tax_Options 0 179 BKTFRTAM Backout Freight Amount Currency DLR19_RBS0_UTR$ 19 180 ORBKTFRT Originating Backout Freight Amount Currency DLR19_RBS0_UTR$ 19 181 BKTMSCAM Backout Misc Amount Currency DLR19_RBS0_UTR$ 19 182 ORBKTMSC Originating Backout Misc Amount Currency DLR19_RBS0_UTR$ 19 183 BCKTXAMT Backout Tax Amount Currency DLR17_RBS0_UTR$ 17 184 OBTAXAMT Originating Backout Tax Amount Currency DLR17_RBS0_UTR$ 17 185 ECTRX EC Transaction Boolean CB_EC_Transaction 0 The field is set to true for each VAT Line Analysis record, if the user marks the transaction as being an EC Transaction.
Click to show/hide Document Printed flag
0 Not an EU Transaction.
1 EU Transaction.186 DOCAMNT Document Amount Currency DLR19_RBSO_UTR$ 19 187 ORDOCAMT Originating Document Amount Currency DLR17_RBS0_STR$ 17 188 PYMTRCVD Payment Received Currency DLR19_RBS0_UTR$ 19 189 ORPMTRVD Originating Payment Received Currency DLR19_RBS0_UTR$ 19 190 DEPRECVD Deposit Received Currency DLR19_RBS0_UTR$ 19 191 ORDEPRVD Originating Deposit Received Currency DLR19_RBS0_UTR$ 19 192 CODAMNT COD Amount Currency DLR17_RBS0_UTR$ 17 193 ORCODAMT Originating COD Amount Currency DLR17_RBS0_UTR$ 17 194 ACCTAMNT Account Amount Currency DLR19_RBS0_UTR$ 19 195 ORACTAMT Originating Account Amount Currency DLR19_RBS0_UTR$ 19 196 UPSZONE UPS Zone String STR3 3 197 TIMESPRT Times Printed Integer INT4_U0 4 198 PSTGSTUS Posting Status Integer INT 0 199 VOIDSTTS Void Status Integer INT 0 200 ALLOCABY Allocate By Integer DDL_Allocate_By 0 201 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CURNCYID AS 'ASI SOP Line Item SmartList-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['ASI SOP Line Item SmartList'].CURNCYID = ['Currency Setup'].CURNCYID202 RATETPID Rate Type ID String STR15_Rate_Type_ID 15 Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].RATETPID AS 'ASI SOP Line Item SmartList-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['ASI SOP Line Item SmartList'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID203 EXGTBLID Exchange Table ID String STR15_Exchange_Table_ID 15 Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].EXGTBLID AS 'ASI SOP Line Item SmartList-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['ASI SOP Line Item SmartList'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID204 XCHGRATE Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 205 DENXRATE Denomination Exchange Rate Currency (Variable) DLR14_Exchange_Rate 14 206 EXCHDATE Exchange Date Date DT_Date 6 207 TIME1 Time Time TM6 6 208 RTCLCMTD Rate Calculation Method Integer GB 0 209 MCTRXSTT MC Transaction State Integer INT1 1 210 SOPHDRE1 SOP HDR Errors 1 Long Integer ML_SOP_HDR_Errors_1 0 211 SOPHDRE2 SOP HDR Errors 2 Long Integer ML_SOP_HDR_Errors_2 0 212 SOPHDRFL SOP HDR Flags Long Integer ML_SOP_HDR_Flags 0 213 REFRENCE Reference String STR30 30 214 POSTEDDT Posted Date Date DATE 6 215 PTDUSRID Posted User ID String STR15 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].PTDUSRID AS 'ASI SOP Line Item SmartList-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ASI SOP Line Item SmartList'].PTDUSRID = ['Users Master'].USERID216 USER2ENT User To Enter String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].USER2ENT AS 'ASI SOP Line Item SmartList-User To Enter'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['ASI SOP Line Item SmartList'].USER2ENT = ['Users Master'].USERID217 CREATDDT Created Date Date DT 8 218 MODIFDT Modified Date Date DT 8 219 Tax_Date Tax Date Date DT 8 220 ITMSHNAM Item Short Name String STR15 15 221 ITEMTYPE Item Type Integer DDL_Item_Type 0 222 ITMGEDSC Item Generic Description String STR10 10 223 STNDCOST Standard Cost Currency DLR17_RBS0_UTR$ 17 224 CURRCOST Current Cost Currency DLR17_RBS0_UTR$ 17 225 LISTPRCE List Price Currency DLR17_RBS0_STR$ 17 226 ITEMSHWT Item Shipping Weight Long Integer LI6_RBS2_UT 6 227 DECPLQTY Decimal Places QTYS Integer DDL_Decimal_Places_QTYS 0 228 DECPLCUR Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 229 TAXOPTNS Tax Options Integer DDL_Tax_Options 0 230 COMMCODE Commission Code String STR15_LBAU 15 231 IVIVINDX IV IV Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVIVINDX AS 'ASI SOP Line Item SmartList-IV IV Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVIVINDX = ['Account Index Master'].ACTINDX232 IVIVOFIX IV IV Offset Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVIVOFIX AS 'ASI SOP Line Item SmartList-IV IV Offset Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVIVOFIX = ['Account Index Master'].ACTINDX233 IVCOGSIX IV COGS Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVCOGSIX AS 'ASI SOP Line Item SmartList-IV COGS Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVCOGSIX = ['Account Index Master'].ACTINDX234 IVSLSIDX IV Sales Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVSLSIDX AS 'ASI SOP Line Item SmartList-IV Sales Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVSLSIDX = ['Account Index Master'].ACTINDX235 IVSLDSIX IV Sales Discounts Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVSLDSIX AS 'ASI SOP Line Item SmartList-IV Sales Discounts Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVSLDSIX = ['Account Index Master'].ACTINDX236 IVSLRNIX IV Sales Returns Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVSLRNIX AS 'ASI SOP Line Item SmartList-IV Sales Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVSLRNIX = ['Account Index Master'].ACTINDX237 IVINUSIX IV In Use Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVINUSIX AS 'ASI SOP Line Item SmartList-IV In Use Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVINUSIX = ['Account Index Master'].ACTINDX238 IVINSVIX IV In Service Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVINSVIX AS 'ASI SOP Line Item SmartList-IV In Service Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVINSVIX = ['Account Index Master'].ACTINDX239 IVDMGIDX IV Damaged Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVDMGIDX AS 'ASI SOP Line Item SmartList-IV Damaged Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVDMGIDX = ['Account Index Master'].ACTINDX240 IVVARIDX IV Variances Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVVARIDX AS 'ASI SOP Line Item SmartList-IV Variances Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVVARIDX = ['Account Index Master'].ACTINDX241 DPSHPIDX Drop Ship Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].DPSHPIDX AS 'ASI SOP Line Item SmartList-Drop Ship Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].DPSHPIDX = ['Account Index Master'].ACTINDX242 PURPVIDX Purchase Price Variance Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].PURPVIDX AS 'ASI SOP Line Item SmartList-Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].PURPVIDX = ['Account Index Master'].ACTINDX243 IVRETIDX Inventory Returns Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVRETIDX AS 'ASI SOP Line Item SmartList-Inventory Returns Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVRETIDX = ['Account Index Master'].ACTINDX244 ASMVRIDX Assembly Variance Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].ASMVRIDX AS 'ASI SOP Line Item SmartList-Assembly Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].ASMVRIDX = ['Account Index Master'].ACTINDX245 ITMCLSCD Item Class Code String STR10_Class_ID 10 Key to the Item Class Setup (IV40400).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].ITMCLSCD AS 'ASI SOP Line Item SmartList-Item Class Code'
,['Item Class Setup'].ITMCLSCD AS 'Item Class Setup-Item Class Code'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
IV40400 AS ['Item Class Setup']
ON
['ASI SOP Line Item SmartList'].ITMCLSCD = ['Item Class Setup'].ITMCLSCD246 ITMTRKOP Item Tracking Option Integer DDL_Track 0 247 LOTTYPE Lot Type String STR10_Lot_Type 10 248 KPERHIST Keep Period History Boolean CB_Keep_Period_History 0 249 KPTRXHST Keep Trx History Boolean CB_Keep_Trx_History 0 250 KPCALHST Keep Calendar History Boolean CB_Keep_Calendar_History 0 251 KPDSTHST Keep Distribution History Boolean CB_Keep_Dist_History 0 252 ALWBKORD Allow Back Orders Boolean CB_Allow_Back_Orders 0 253 VCTNMTHD Valuation Method Integer DDL_Valuation_Method 0 254 UOMSCHDL U Of M Schedule String STR10_Schedule 10 Key to the Inventory U of M Schedule Setup (IV40201).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].UOMSCHDL AS 'ASI SOP Line Item SmartList-U Of M Schedule'
,['Inventory U of M Schedule Setup'].UOMSCHDL AS 'Inventory U of M Schedule Setup-U Of M Schedule'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
IV40201 AS ['Inventory U of M Schedule Setup']
ON
['ASI SOP Line Item SmartList'].UOMSCHDL = ['Inventory U of M Schedule Setup'].UOMSCHDL255 ObjRef1 ObjRef1 Invalid storage type 30 Reference 0 256 ALTITEM1 Alternate Item 1 String STR30_Item_Number 30 257 ALTITEM2 Alternate Item 2 String STR30_Item_Number 30 258 USCATVLS_1 User Category Values[1] String User_Category_Value 10 259 USCATVLS_2 User Category Values[2] String User_Category_Value 10 260 USCATVLS_3 User Category Values[3] String User_Category_Value 10 261 USCATVLS_4 User Category Values[4] String User_Category_Value 10 262 USCATVLS_5 User Category Values[5] String User_Category_Value 10 263 USCATVLS_6 User Category Values[6] String User_Category_Value 10 264 MSTRCDTY Master Record Type Integer INT1 1 265 WRNTYDYS Warranty Days Integer INT4 4 266 ORIGNUMB Original Number String STR20_SOP_Number 17 267 DISAVTKN Discount Available Taken Currency DLR17_RBS0_UTR$ 17 268 TIMETREP Times To Repeat Integer INT4_U0 4 269 ORDDLRAT Originating Discount Dollar Amount Currency DLR11_RBS0_UTR$ 11 270 SOPMCERR SOP MC Posting Error Messages Long Integer SOP MC Posting Error Messages 0 271 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].NOTEINDX AS 'ASI SOP Line Item SmartList-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['ASI SOP Line Item SmartList'].NOTEINDX = ['Record Notes Master'].NOTEINDX272 CUSTCLAS Customer Class String STR15_Customer_Class 15 273 CPRCSTNM Corporate Customer Number String STR15_RM_Customer_Number 15 274 STMTNAME Statement Name String STR64 64 275 ADRSCODE Address Code String STR15_Address_Code 15 276 STADDRCD Statement Address Code String STR15_LBAU 15 277 CHEKBKID Checkbook ID String STR15_Checkbook_ID 15 Key to the CM Checkbook Master (CM00100).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CHEKBKID AS 'ASI SOP Line Item SmartList-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['ASI SOP Line Item SmartList'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID278 CRLMTTYP Credit Limit Type Integer GB_Amt_Type 0 279 CRLMTAMT Credit Limit Amount Currency DLR17_RBS0_UTR$ 17 280 CRLMTPER Credit Limit Period Integer DDL 0 281 CRLMTPAM Credit Limit Period Amount Currency DLR17_RBS0_UTR$ 17 282 CUSTDISC Customer Discount Integer INT5_%2 5 283 SHRTNAME Short Name String STR15 15 284 MINPYTYP Minimum Payment Type Integer GB_Amt_Type 0 285 MINPYDLR Minimum Payment Dollar Currency DLR17_RBS0_UTR$ 17 286 MINPYPCT Minimum Payment Percent Integer INT5_%2 5 287 FNCHATYP Finance Charge Amt Type Integer GB_Amt_Type 0 288 FNCHPCNT Finance Charge Percent Integer INT5_%2 5 289 FINCHDLR Finance Charge Dollar Currency DLR17_RBS0_UTR$ 17 290 MXWOFTYP Maximum Writeoff Type Integer GP_Max_Writeoff 0 291 MXWROFAM Max Writeoff Amount Currency DLR17_RBS0_UTR$ 17 292 USERDEF1 User Defined 1 String STR20 20 293 USERDEF2 User Defined 2 String STR20 20 294 BALNCTYP Balance Type Integer GB_Bal_Type 0 295 STMTCYCL Statement Cycle Integer DDL_Stmt_Cycle 0 296 BANKNAME Bank Name String STR30 30 297 BNKBRNCH Bank Branch String STR20 20 298 DEFCACTY Default Cash Account Type Integer GB 0 299 RMCSHACC RM Cash Account Index Long Integer LI_14 14 300 RMARACC RM AR Account Index Long Integer LI_14 14 301 RMSLSACC RM Sales Account Index Long Integer LI_14 14 302 RMIVACC RM IV Account Index Long Integer LI_14 14 303 RMCOSACC RM Cost Of Sales Account Index Long Integer LI_14 14 304 RMTAKACC RM Discounts Taken Account Index Long Integer LI_14 14 305 RMAVACC RM Discounts Avail Account Index Long Integer LI_14 14 306 RMFCGACC RM Finance Charge Account Index Long Integer LI_14 14 307 RMWRACC RM Writeoff Account Index Long Integer LI_14 14 308 FRSTINDT First Invoice Date Date DT_Date 6 309 INACTIVE Inactive Boolean CB_Inactive 0 310 HOLD Hold Boolean CB_Hold 0 311 CRCARDID Credit Card ID String STR15 15 312 CRCRDNUM Credit Card Number String STR20 20 313 CCRDXPDT Credit Card Exp Date Date DT_Date 6 314 Revalue_Customer Revalue Customer Boolean CB Revalue Customer 0 315 Post_Results_To Post Results To Integer GB 0 316 FINCHID Finance Charge ID String STR15_Charge_ID 15 317 GOVCRPID Governmental Corporate ID String STR30_Gov_Corp_ID 30 318 GOVINDID Governmental Individual ID String STR30_Gov_Indiv_ID 30 319 TNSFCLIF Total Amount Of NSF Checks Life Currency DLR19_RBS0_STR$ 19 320 NONSFLIF Number Of NSF Checks Life Long Integer LI6_U0 6 321 CUSTBLNC Customer Balance Currency DLR19_RBS0_STR$ 19 322 AGPERAMT_1 Aging Period Amounts[1] Currency DLR17_RBSO_STR$ 17 323 AGPERAMT_2 Aging Period Amounts[2] Currency DLR17_RBSO_STR$ 17 324 AGPERAMT_3 Aging Period Amounts[3] Currency DLR17_RBSO_STR$ 17 325 AGPERAMT_4 Aging Period Amounts[4] Currency DLR17_RBSO_STR$ 17 326 AGPERAMT_5 Aging Period Amounts[5] Currency DLR17_RBSO_STR$ 17 327 AGPERAMT_6 Aging Period Amounts[6] Currency DLR17_RBSO_STR$ 17 328 AGPERAMT_7 Aging Period Amounts[7] Currency DLR17_RBSO_STR$ 17 329 LASTAGED Last Aged Date DATE 6 330 LSTNSFCD Last NSF Check Date Date DT_Date 6 331 LPYMTAMT Last Payment Amount Currency DLR17_RBS0_STR$ 17 332 LASTPYDT Last Payment Date Date DT_Date 6 333 LSTTRXDT Last Transaction Date Date DT_Date 6 334 LSTTRXAM Last Transaction Amount Currency DLR17_RBS0_STR$ 17 335 LSTFCHAM Last Finance Charge Amount Currency DLR19_RBS0_STR$ 19 336 UPFCHYTD Unpaid Finance Charges YTD Currency DLR17_RBS0_UTR$ 17 337 AVDTPLYR Average Days to Pay - LYR Integer INT3_U0 3 338 AVDTPLIF Average Days To Pay - Life Integer INT3_U0 3 339 AVGDTPYR Average Days To Pay - Year Integer INT3_U0 3 340 NUMADTPL Number ADTP Documents - Life Long Integer Long_10U 10 341 NUMADTPR Number ADTP Documents - LYR Long Integer Long_10U 10 342 NUMADTPY Number ADTP Documents - Year Long Integer Long_10U 10 343 TDTKNLTD Total Discounts Taken LTD Currency DLR19_RBS0_STR$ 19 344 TDTKNLYR Total Discounts Taken LYR Currency DLR19_RBS0_STR$ 19 345 TDTKNYTD Total Discounts Taken YTD Currency DLR19_RBS0_STR$ 19 346 TDISAYTD Total Discounts Available YTD Currency DLR19_RBS0_STR$ 19 347 RETAINAG Retainage Currency DLR19_RBS0_STR$ 19 348 TNSFCYTD Total Amount Of NSF Checks YTD Currency DLR19_RBS0_STR$ 19 349 NONSFYTD Number Of NSF Checks YTD Long Integer LI6_U0 6 350 UNPSTDSA Unposted Sales Amount Currency DLR19_RBS0_UTR$ 19 351 UNPSTDCA Unposted Cash Amount Currency DLR19_RBS0_UTR$ 19 352 UNPSTOSA Unposted Other Sales Amount Currency DLR19_RBS0_UTR$ 19 353 UNPSTOCA Unposted Other Cash Amount Currency DLR19_RBS0_UTR$ 19 354 NCSCHPMT Non Current Scheduled Payments Currency DLR19_RBS0_STR$ 19 355 TTLSLLTD Total Sales LTD Currency DLR19_RBS0_STR$ 19 356 TTLSLLYR Total Sales LYR Currency DLR19_RBS0_STR$ 19 357 TTLSLYTD Total Sales YTD Currency DLR19_RBS0_STR$ 19 358 TCOSTLTD Total Costs LTD Currency DLR19_RBS0_STR$ 19 359 TCOSTLYR Total Costs LYR Currency DLR19_RBS0_STR$ 19 360 TCOSTYTD Total Costs YTD Currency DLR19_RBS0_STR$ 19 361 TCSHRLTD Total Cash Received LTD Currency DLR19_RBS0_STR$ 19 362 TCSHRLYR Total Cash Received LYR Currency DLR19_RBS0_STR$ 19 363 TCSHRYTD Total Cash Received YTD Currency DLR19_RBS0_STR$ 19 364 TFNCHLTD Total Finance Charges LTD Currency DLR19_RBS0_STR$ 19 365 TFNCHLYR Total Finance Charges LYR Currency DLR19_RBS0_STR$ 19 366 TFNCHYTD Total Finance Charges YTD Currency DLR19_RBS0_STR$ 19 367 FNCHCYTD Finance Charges CYTD Currency DLR19_RBS0_STR$ 19 368 FNCHLYRC Finance Charges LYR Calendar Currency DLR19_RBS0_STR$ 19 369 TBDDTLYR Total Bad Deb LYR Currency DLR19_RBS0_STR$ 19 370 TBDDTLTD Total Bad Debt LTD Currency DLR19_RBS0_STR$ 19 371 TBDDTYTD Total Bad Debt YTD Currency DLR19_RBS0_STR$ 19 372 TWVFCLTD Total Waived FC LTD Currency DLR19_RBS0_STR$ 19 373 TWVFCLYR Total Waived FC LYR Currency DLR19_RBS0_STR$ 19 374 TWVFCYTD Total Waived FC YTD Currency DLR19_RBS0_STR$ 19 375 TWROFLTD Total Writeoffs LTD Currency DLR19_RBS0_STR$ 19 376 TWROFLYR Total Writeoffs LYR Currency DLR19_RBS0_STR$ 19 377 TWROFYTD Total Writeoffs YTD Currency DLR19_RBS0_STR$ 19 378 TTLINLTD Total # Invoices LTD Long Integer LI6_U0 6 379 TTLINLYR Total # Invoices LYR Long Integer LI6_U0 6 380 TTLINYTD Total # Invoices YTD Long Integer LI6_U0 6 381 TTLFCLTD Total # FC LTD Long Integer LI6_U0 6 382 TTLFCLYR Total # FC LYR Long Integer LI6_U0 6 383 TTLFCYTD Total # FC YTD Long Integer LI6_U0 6 384 WROFSLIF Write Offs LIFE Currency DLR19_RBS0_STR$ 19 385 WROFSLYR Write Offs LYR Currency DLR19_RBS0_STR$ 19 386 WROFSYTD Write Offs YTD Currency DLR19_RBS0_STR$ 19 387 HIBALLTD High Balance LTD Currency DLR19_RBSO_STR$ 19 388 HIBALLYR High Balance LYR Currency DLR19_RBSO_STR$ 19 389 HIBALYTD High Balance YTD Currency DLR19_RBSO_STR$ 19 390 LASTSTDT Last Statement Date Date DATE 6 391 LSTSTAMT Last Statement Amount Currency DLR17_RBS0_STR$ 17 392 DEPRECV Deposits Received Currency DLR19_RBS0_STR$ 19 393 ONORDAMT On Order Amount Currency DLR19_RBS0_UTR$ 19 394 DISGRPER Discount Grace Period Integer INT2_U0 2 395 DOCFMTID Document Format ID String STR15_LBU 15 396 DUEGRPER Due Date Grace Period Integer INT2_U0 2 397 APLYWITH Apply Withholding Boolean Boolean 0 398 CORRCTN Correction Boolean CB_Correction 0 399 DOCNCORR Document Number Corrected String Document_Number 20 400 PHONE3 Phone 3 String Phone_Number3 14 401 SALEDATE Sale Date Date DT 8 402 SEQNCORR Sequence Number Corrected Integer INT 0 403 SHPPGDOC Shipping Document Boolean CB_Shipping_Document 0 404 SIMPLIFD Simplified Boolean CB_Simplified 0 405 WITHHAMT Withholding Amount Currency DLR19_RBSO_UTR$ 19 406 CORRNXST Correction to Nonexisting Transaction Boolean Boolean 0 407 SOPHDRE3 SOP HDR Errors 3 Long Integer ML_SOP_HDR_Errors_3 0 408 ABCCODE ABC Code Integer DDL_ABC_Code 0 409 CGSINFLX COGS Inflation Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CGSINFLX AS 'ASI SOP Line Item SmartList-COGS Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].CGSINFLX = ['Account Index Master'].ACTINDX410 CGSMCIDX COGS Monetary Correction Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].CGSMCIDX AS 'ASI SOP Line Item SmartList-COGS Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].CGSMCIDX = ['Account Index Master'].ACTINDX411 IVINFIDX Inventory Inflation Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].IVINFIDX AS 'ASI SOP Line Item SmartList-Inventory Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].IVINFIDX = ['Account Index Master'].ACTINDX412 INVMCIDX Inventory Monetary Correction Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].INVMCIDX AS 'ASI SOP Line Item SmartList-Inventory Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].INVMCIDX = ['Account Index Master'].ACTINDX413 ITEMCODE Item Code String STR15 15 414 KTACCTSR Kit COGS Account Source Integer GB 0 415 LASTGENSN Last Generated Serial Number String STR20_LBAU 20 416 PriceGroup Price Group String STR10_LBAU 10 417 PRICMTHD Price Method Integer DDL_Price_Method 0 418 PINFLIDX Purch Inflation Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].PINFLIDX AS 'ASI SOP Line Item SmartList-Purch Inflation Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].PINFLIDX = ['Account Index Master'].ACTINDX419 PURMCIDX Purch Monetary Correction Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].PURMCIDX AS 'ASI SOP Line Item SmartList-Purch Monetary Correction Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].PURMCIDX = ['Account Index Master'].ACTINDX420 PRCHSUOM Purchasing U Of M String U_Of_M 8 421 SELNGUOM Selling U Of M String U_Of_M 8 422 TCC Tax Commodity Code String STR30_VAT 30 423 UPPVIDX Unrealized Purchase Price Variance Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['ASI SOP Line Item SmartList'].UPPVIDX AS 'ASI SOP Line Item SmartList-Unrealized Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP20 AS ['ASI SOP Line Item SmartList']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['ASI SOP Line Item SmartList'].UPPVIDX = ['Account Index Master'].ACTINDX424 ORGSEQNM Original Sequence Number Corrected Long Integer LI_Sequence_Number 10 425 ODECPLCU Originating Decimal Places Currency Integer DDL_Decimal_Places_Dollars 0 426 TTLRTLTD Total Returns LTD Currency DLR19_RBS0_STR$ 19 427 TTLRTLYR Total Returns LYR Currency DLR19_RBS0_STR$ 19 428 TTLRTYTD Total Returns YTD Currency DLR19_RBS0_STR$ 19 429 CUSTNAME1 ASI_Customer_Name String STR64_Customer_Name 64 430 CNTCPRSN1 ASI_Contact_Person String STR60 60 431 ASI_Address_Code ASI_Address_Code String STR15_Address_Code 15 432 UPSZONE1 ASI_UPS_Zone String STR3 3 433 SHIPMTHD1 ASI_Shipping_Method String STR15_Shipping_Method 15 434 TAXSCHID1 ASI_Tax_Schedule_ID String STR15_Tax_Schedule_ID 15 435 ADDRESS11 ASI_Address_1 String STR60 60 436 ADDRESS21 ASI_Address_2 String STR60 60 437 ADDRESS31 ASI_Address_3 String STR60 60 438 COUNTRY1 ASI_Country String STR60 60 439 CITY1 ASI_City String STR35 35 440 STATE1 ASI_State String STR30_State 29 441 ZIP1 ASI_Zip String STR10 10 442 PHONE11 ASI_Phone_1 String Phone_Number 14 443 PHONE21 ASI_Phone_2 String Phone_Number 14 444 FAX1 ASI_Fax String STR14_FAX 14 445 PRBTADCD1 ASI_Primary_Billto_Address_Code String STR15_LBAU 15 446 PRSTADCD1 ASI_Primary_Shipto_Address_Code String STR15_LBAU 15 447 SLPRSNID1 ASI_Salesperson_ID String STR15_Salesperson_ID 15 448 PYMTRMID1 ASI_Payment_Terms_ID String STR20_Payment_Terms_ID 20 449 CURNCYID1 ASI_Currency_ID String STR15_Currency_ID 15 450 RATETPID1 ASI_Rate_Type_ID String STR15_Rate_Type_ID 15 451 PRCLEVEL1 ASI_PriceLevel String STR10_LBAU 10 452 COMMENT11 ASI_Comment1 String STR30 30 453 COMMENT21 ASI_Comment2 String STR30 30 454 TXRGNNUM1 ASI_Tax_Registration_Number String STR25 25 455 TAXEXMT11 ASI_Tax_Exempt_1 String STR25 25 456 TAXEXMT21 ASI_Tax_Exempt_2 String STR25 25 457 SALSTERR1 ASI_Sales_Territory String STR15_Sales_Territory 15 458 KPCALHST1 ASI_Keep_Calendar_History Boolean CB_Keep_Calendar_History 0 459 KPDSTHST1 ASI_Keep_Distribution_History Boolean CB_Keep_Dist_History 0 460 KPERHIST1 ASI_Keep_Period_History Boolean CB_Keep_Period_History 0 461 KPTRXHST1 ASI_Keep_Trx_History Boolean CB_Keep_Trx_History 0 462 NOTEINDX1 ASI_Note_Index Currency DLR14 14 463 CREATDDT1 ASI_Created_Date Date DT 8 464 MODIFDT1 ASI_Modified_Date Date DT 8 465 PHONE31 ASI_Phone_3 String Phone_Number 14 466 ITEMDESC1 ASI_Item_Description String STR50 50 467 ITMTSHID1 ASI_Item_Tax_Schedule_ID String STR15_LBAU 15 468 PRCLEVEL11 ASI_PriceLevel2 String STR10_LBAU 10 469 DECPLQTY1 ASI_Decimal_Places_QTYS Integer DDL_Decimal_Places_QTYS 0 470 DECPLCUR1 ASI_Decimal_Places_Currency Integer DDL_Decimal_Places_Dollars 0 471 ITEMCODE1 ASI_Item_Code String STR15 15 472 ReqShipDate1 ASI_Requested_Ship_Date Date DT 8 473 FUFILDAT1 ASI_Fulfillment_Date Date DT 8 474 ACTLSHIP1 ASI_Actual_Ship_Date Date DT 8 475 PRCLEVEL111 ASI_PriceLevel3 String STR10_LBAU 10 476 LOCNCODE1 ASI_Location_Code String STR10_Location_Code 10 477 MRKDNAMT1 ASI_Markdown_Amount Currency DLR17_RBS0_UTR$ 17 478 SHIPMTHD11 ASI_Shipping_Method2 String STR15_Shipping_Method 15 479 TRDISAMT1 ASI_Trade_Discount_Amount Currency DLR17_RBS0_UTR$ 17 480 EXTDCOST1 ASI_Extended_Cost Currency DLR17_RBS0_UTR$ 17 481 TXBTXAMT1 ASI_Taxable_Tax_Amount Currency DLR19_RBSO_UTR$ 19 482 TAXAMNT1 ASI_Tax_Amount Currency DLR17_RBS0_UTR$ 17 483 SALSTERR11 ASI_Sales_Territory2 String STR15_Sales_Territory 15 484 SLPRSNID11 ASI_Salesperson_ID2 String STR15_Salesperson_ID 15 485 TRXSORCE1 ASI_TRX_Source String STR13 13 486 COMMNTID1 ASI_Comment_ID String STR15_Comment_ID 15 487 CREATDDT11 ASI_Created_Date2 Date DT 8 488 MODIFDT11 ASI_Modified_Date2 Date DT 8 489 ORMRKDAM1 ASI_Originating_Markdown_Amount Currency DLR17_RBS0_UTR$ 17 490 ORTDISAM1 ASI_Originating_Trade_Discount_Amount Currency DLR17_RBS0_UTR$ 17 491 BSIVCTTL1 ASI_Based_On_Invoice_Total Boolean YN 0 492 OREXTCST1 ASI_Originating_Extended_Cost Currency DLR17_RBS0_UTR$ 17 493 OTAXTAMT1 ASI_Originating_Taxable_Tax_Amount Currency DLR17_RBS0_UTR$ 17 494 ORTAXAMT1 ASI_Originating_Tax_Amount Currency DLR17_RBS0_UTR$ 17 495 NOTEINDX11 ASI_Note_Index2 Currency DLR14 14 496 ASI_Currency_Index ASI_Currency_Index Integer INT3 3 497 SOPLNERR1 ASI_SOP_LINE_Errors_MSLB Long Integer ML_SOP_LINE_Errors 0 498 LOCNCODE11 ASI_Location_Code2 String STR10_Location_Code 10 499 DOCNCORR1 ASI_Document_Number_Corrected String Document_Number 20 500 TAXSCHID2 ASI_Tax_Schedule_ID_2 String STR15_Tax_Schedule_ID 15 501 PRSTADCD2 ASI_Primary_Shipto_Address_Code_2 String STR15_LBAU 15 502 ShipToName1 ASI_ShipToName String STR64_Customer_Name 64 503 CNTCPRSN2 ASI_Contact_Person_2 String STR60 60 504 ADDRESS111 ASI_Address_12 String STR60 60 505 ADDRESS211 ASI_Address_22 String STR60 60 506 ADDRESS311 ASI_Address_32 String STR60 60 507 CITY11 ASI_City2 String STR35 35 508 STATE11 ASI_State2 String STR30_State 29 509 ZIPCODE1 ASI_Zip_Code String STR10 10 510 COUNTRY11 ASI_Country2 String STR60 60 511 PHONE1 Phone 1 String Phone_Number 14 512 PHONE2 Phone 2 String Phone_Number 14 513 PHONE311 ASI_Phone_32 String Phone_Number 14 514 FAXNUMBR1 ASI_Fax_Number String STR14_FAX 14 515 EXCEPTIONALDEMAND Exceptional Demand Boolean CB_Exceptional_Demand 0 516 ASI_Tax_Schedule_Source ASI_Tax_Schedule_Source Integer ASI_Tax_Schedule_Source 0 517 CONTNBR Contract Number String STR11 11 518 CONTSTARTDTE Contract Start Date Date DATE 6 519 CONTENDDTE Contract End Date Date DATE_L 0 520 CONTITEMNBR Contract Item Number String STR30_Item_Number 30 521 CONTSERIALNBR Contract Serial Number String STR20_LBAU 20 522 SOPSTATUS SOP Status Integer INT 0 523 CUSTPRIORITY Customer Priority Integer DDL_CustomerPriority 0 524 ORDERFULFILLDEFAULT Order Fulfillment Shortage Default Integer DDL_OrderFulfillDefault 0 525 UMSCHDSC U Of M Schedule Description String STR30 30 526 SHIPCOMPLETE Ship Complete Document Boolean CB_ShipComplete 0 527 SHIPCOMPLETE1 ASI_Ship_Complete_Document Boolean CB_ShipComplete 0