Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/ASIEXP09
Product: SmartList (1493)
Series:
Display Name: SmartList Payables Transactions Group Display Name: SmartList Master
Physical Name: ASIEXP09
Technical Name: ASI_PM_Document_Explorer
Group Technical Name: ASI_Explorer_Logical_MSTR
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | ASI_Order_By  | ASI_Order_By | Long Integer | LI_14 | 14 | |
| 2 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
| 3 | BCHSOURC | Batch Source | String | STR15 | 15 | |
| 4 | VENDORID | Vendor ID | String | STR_15_Vendor_ID | 15 | |
Key to the PM Vendor Master File (PM00200).
Click to show/hideSELECT
['SmartList Payables Transactions'].VENDORID AS 'SmartList Payables Transactions-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['SmartList Payables Transactions'].VENDORID = ['PM Vendor Master File'].VENDORID | ||||||
| 5 | DOCNUMBR | Document Number | String | STR20_Document_Number | 20 | |
| 6 | DOCTYPE | Document Type | Integer | DDL_Document_Type | 0 | |
| 7 | ASI_Document_Status | ASI_Document_Status | Integer | INT | 0 | |
| 8 | SOURCDOC | Source Document | String | STR10_Source_Document | 10 | |
Key to the Source Document Master (SY00900).
Click to show/hideSELECT
['SmartList Payables Transactions'].SOURCDOC AS 'SmartList Payables Transactions-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['SmartList Payables Transactions'].SOURCDOC = ['Source Document Master'].SOURCDOC | ||||||
| 9 | DOCAMNT | Document Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 10 | DOCDATE | Document Date | Date | DT | 8 | |
| 11 | PSTGDATE | Posting Date | Date | DT | 8 | |
| 12 | VADDCDPR | Vendor Address Code - Primary | String | STR15_Address_Code | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['SmartList Payables Transactions'].VADDCDPR AS 'SmartList Payables Transactions-Vendor Address Code - Primary'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList Payables Transactions'].VADDCDPR = ['PM Address MSTR'].ADRSCODE
AND
['SmartList Payables Transactions'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
| 13 | PYMTRMID | Payment Terms ID | String | STR20_Payment_Terms_ID | 20 | |
Key to the Payment Terms Master (SY03300).
Click to show/hideSELECT
['SmartList Payables Transactions'].PYMTRMID AS 'SmartList Payables Transactions-Payment Terms ID'
,['Payment Terms Master'].PYMTRMID AS 'Payment Terms Master-Payment Terms ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
SY03300 AS ['Payment Terms Master']
ON
['SmartList Payables Transactions'].PYMTRMID = ['Payment Terms Master'].PYMTRMID | ||||||
| 14 | TAXSCHID | Tax Schedule ID | String | STR15_Tax_Schedule_ID | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['SmartList Payables Transactions'].TAXSCHID AS 'SmartList Payables Transactions-Tax Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Payables Transactions'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 15 | DUEDATE | Due Date | Date | DT | 8 | |
| 16 | DSCDLRAM | Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
| 17 | DISCDATE | Discount Date | Date | DT | 8 | |
| 18 | PRCHAMNT | Purchases Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 19 | CHRGAMNT | Charge Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 20 | CASHAMNT | Cash Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 21 | CAMCBKID | Cash Amount Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['SmartList Payables Transactions'].CAMCBKID AS 'SmartList Payables Transactions-Cash Amount Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['SmartList Payables Transactions'].CAMCBKID = ['CM Checkbook Master'].CHEKBKID | ||||||
| 22 | CDOCNMBR | Cash Document Number | String | STR20_Document_Number | 20 | |
| 23 | CAMTDATE | Cash Amount Date | Date | DT | 8 | |
| 24 | CAMPMTNM | Cash Amount Payment Number | String | STR20_LBAU | 20 | |
| 25 | CHEKAMNT | Check Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 26 | CHAMCBID | Check Amount Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['SmartList Payables Transactions'].CHAMCBID AS 'SmartList Payables Transactions-Check Amount Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['SmartList Payables Transactions'].CHAMCBID = ['CM Checkbook Master'].CHEKBKID | ||||||
| 27 | CHEKDATE | Check Date | Date | DATE | 6 | |
| 28 | CAMPYNBR | Check Amount Payment Number | String | STR20_LBAU | 20 | |
| 29 | CRCRDAMT | Credit Card Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 30 | CCAMPYNM | Credit Card Amount Payment Number | String | STR20_LBAU | 20 | |
| 31 | CHEKNMBR | Check Number | String | STR20_Document_Number | 20 | |
| 32 | CARDNAME | Card Name | String | STR15_Card_Name | 15 | |
| 33 | CCRCTNUM | Credit Card Receipt Number | String | STR20_Document_Number | 20 | |
| 34 | CRCARDDT | Credit Card Date | Date | DATE | 6 | |
| 35 | CURNCYID | Currency ID | String | STR15_Currency_ID | 15 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['SmartList Payables Transactions'].CURNCYID AS 'SmartList Payables Transactions-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SmartList Payables Transactions'].CURNCYID = ['Currency Setup'].CURNCYID | ||||||
| 36 | CHEKBKID | Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['SmartList Payables Transactions'].CHEKBKID AS 'SmartList Payables Transactions-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['SmartList Payables Transactions'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID | ||||||
| 37 | TRXDSCRN | Transaction Description | String | STR30 | 30 | |
| 38 | UN1099AM | Unapplied 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 39 | TRDISAMT | Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 40 | TAXAMNT | Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 41 | FRTAMNT | Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 42 | TEN99AMNT | 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 43 | MSCCHAMT | Misc Charges Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 44 | PORDNMBR | Purchase Order Number | String | Purchase Order Number | 20 | |
| 45 | SHIPMTHD | Shipping Method | String | STR15_Shipping_Method | 15 | |
Key to the Shipping Methods Master (SY03000).
Click to show/hideSELECT
['SmartList Payables Transactions'].SHIPMTHD AS 'SmartList Payables Transactions-Shipping Method'
,['Shipping Methods Master'].SHIPMTHD AS 'Shipping Methods Master-Shipping Method'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
SY03000 AS ['Shipping Methods Master']
ON
['SmartList Payables Transactions'].SHIPMTHD = ['Shipping Methods Master'].SHIPMTHD | ||||||
| 46 | DISAMTAV | Discount Amount Available | Currency | DLR17_RBS0_UTR$ | 17 | |
| 47 | DISTKNAM | Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 48 | APDSTKAM | Applied Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 49 | WROFAMNT | Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 50 | CURTRXAM | Current Trx Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 51 | TXENGCLD | Tax Engine Called | Boolean | YN | 0 | |
| 52 | PMWRKMSG | PM WORK Messages | Long Integer | ML_PM_WORK_Messages | 0 | |
| 53 | PMDSTMSG | PM Distribution Messages | Long Integer | ML_PM_Distribution_Messages | 0 | |
| 54 | GSTDSAMT | GST Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 55 | PGRAMSBJ | Percent Of Gross Amount Subject | Integer | INT5_RBS2_U% | 5 | |
| 56 | PPSAMDED | PPS Amount Deducted | Currency | DLR17_RBS0_UTR$ | 17 | |
| 57 | PPSTAXRT | PPS Tax Rate | Integer | INT5_%2 | 5 | |
| 58 | POSTED | Posted | Boolean | True/False | 0 | |
| 59 | APPLDAMT | Applied Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 60 | VCHRNMBR | Voucher Number | String | STR20_LBAU | 20 | |
| 61 | CNTRLTYP | Control Type | Integer | INT1 | 1 | |
| 62 | MODIFDT | Modified Date | Date | DT | 8 | |
| 63 | MDFUSRID | Modified User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['SmartList Payables Transactions'].MDFUSRID AS 'SmartList Payables Transactions-Modified User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SmartList Payables Transactions'].MDFUSRID = ['Users Master'].USERID | ||||||
| 64 | POSTEDDT | Posted Date | Date | DATE | 6 | |
| 65 | PTDUSRID | Posted User ID | String | STR15 | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['SmartList Payables Transactions'].PTDUSRID AS 'SmartList Payables Transactions-Posted User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['SmartList Payables Transactions'].PTDUSRID = ['Users Master'].USERID | ||||||
| 66 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['SmartList Payables Transactions'].NOTEINDX AS 'SmartList Payables Transactions-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SmartList Payables Transactions'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 67 | BKTFRTAM | Backout Freight Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 68 | BKTMSCAM | Backout Misc Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 69 | BKTPURAM | Backout Purchases Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 70 | PCHSCHID | Purchase Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['SmartList Payables Transactions'].PCHSCHID AS 'SmartList Payables Transactions-Purchase Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Payables Transactions'].PCHSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 71 | FRTSCHID | Freight Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['SmartList Payables Transactions'].FRTSCHID AS 'SmartList Payables Transactions-Freight Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Payables Transactions'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 72 | MSCSCHID | Misc Schedule ID | String | STR15_LBAU | 15 | |
Key to the Sales/Purchases Tax Schedule Header Master (TX00101).
Click to show/hideSELECT
['SmartList Payables Transactions'].MSCSCHID AS 'SmartList Payables Transactions-Misc Schedule ID'
,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
TX00101 AS ['Sales/Purchases Tax Schedule Header Master']
ON
['SmartList Payables Transactions'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID | ||||||
| 73 | PRINTED | Printed | Boolean | CB | 0 | |
Click to show/hide Printed flag
0 Record has not been printed.
1 Record has been printed. | ||||||
| 74 | PRCTDISC | Percent Discount | Integer | INT5_%2 | 5 | |
| 75 | RETNAGAM | Retainage Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 76 | ICTRX | IC TRX | Boolean | CB_IC_TRX | 0 | |
Click to show/hide Intercompany flag
0 Not intercompany.
1 Intercompany | ||||||
| 77 | ICDISTS | ICDists | Boolean | Boolean | 0 | |
Click to show/hide Intercompany distirubtions
0 Not intercompany.
1 Intercompany distributions present. | ||||||
| 78 | PMICMSGS | ICMessages | Long Integer | ML_IC_Post_Messages | 0 | |
Error messages from posting an Intercompany Transaction.
Click to show/hide Intercompany posting error messages
1 The currency ID is missing.
2 A destination company does not have access to this currency ID.
3 The currency ID is inactive for a destination company.
4 A rate type ID is missing for a destination company.
5 Rate type ID is not associated with the currency ID for a destination
company.
6 An exchange table ID is missing for a destination company.
7 A destination company does not have access to an exchange table ID.
8 An exchange table ID is inactive for a destination company.
9 An exchange rate does not exist for a destination company.
10 An exchange rate has expired for a destination company.
11 Cannot post intercompany multicurrency transactions to a recurring batch.
12 A rounding account missing for a destination company.
13 A distribution type is invalid for a destination company distribution.
14 A destination company distribution contains MDA information.
15 A destination company ID does not exist; please select another company ID.
16 The user does not have access to a destination company.
17 A destination company does not have a functional currency set up.
18 Destination functional currency doesn't match originating functional currency.
19 No relationship exists between originating company and a destination company.
20 Due To / Due From account not specified.
21 The rounding account does not exist for the originating company.
22 Unknown SQL error occurred.
23 Intrastat information is missing or invalid.
24 The goods value for Intrastat exceeds the document total.
25 Transaction has successfully posted. | ||||||
| 79 | Tax_Date | Tax Date | Date | DT | 8 | |
| 80 | DISCAMNT | Discount Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 81 | TRXSORCE | TRX Source | String | STR13 | 13 | |
| 82 | VOIDED | Voided | Boolean | CB | 0 | |
| 83 | HOLD | Hold | Boolean | CB_Hold | 0 | |
| 84 | DINVPDOF | Date Invoice Paid Off | Date | DT | 8 | |
| 85 | PYENTTYP | Payment Entry Type | Integer | GB | 0 | |
| 86 | TTLPYMTS | Total Payments | Currency | DLR19_RBS0_UTR$ | 19 | |
| 87 | DISAVTKN | Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 88 | VOIDPDATE | Void GL Posting Date | Date | DT | 8 | |
| 89 | ASI_Favorite_Sequence | ASI_Favorite_Sequence | Long Integer | ASI_LI_10_RU | 10 | |
| 90 | DCSTATUS | Document Status | Integer | DDL_Doc_Status | 0 | |
| 91 | PMNTNMBR | Payment Number | String | STR20_LBAU | 20 | |
| 92 | CURRNIDX | Currency Index | Integer | INT3 | 3 | |
Key to the Currency Setup (MC40200).
Click to show/hideSELECT
['SmartList Payables Transactions'].CURRNIDX AS 'SmartList Payables Transactions-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['SmartList Payables Transactions'].CURRNIDX = ['Currency Setup'].CURRNIDX | ||||||
| 93 | RATETPID | Rate Type ID | String | STR15_Rate_Type_ID | 15 | |
Key to the Multicurrency Rate Type Setup (MC40100).
Click to show/hideSELECT
['SmartList Payables Transactions'].RATETPID AS 'SmartList Payables Transactions-Rate Type ID'
,['Multicurrency Rate Type Setup'].RATETPID AS 'Multicurrency Rate Type Setup-Rate Type ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
MC40100 AS ['Multicurrency Rate Type Setup']
ON
['SmartList Payables Transactions'].RATETPID = ['Multicurrency Rate Type Setup'].RATETPID | ||||||
| 94 | EXGTBLID | Exchange Table ID | String | STR15_Exchange_Table_ID | 15 | |
Key to the Multicurrency Exchange Rate Maintenance (MC00100).
Click to show/hideSELECT
['SmartList Payables Transactions'].EXGTBLID AS 'SmartList Payables Transactions-Exchange Table ID'
,['Multicurrency Exchange Rate Maintenance'].EXGTBLID AS 'Multicurrency Exchange Rate Maintenance-Exchange Table ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
DYNAMICS..MC00100 AS ['Multicurrency Exchange Rate Maintenance']
ON
['SmartList Payables Transactions'].EXGTBLID = ['Multicurrency Exchange Rate Maintenance'].EXGTBLID | ||||||
| 95 | XCHGRATE | Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 96 | EXCHDATE | Exchange Date | Date | DT_Date | 6 | |
| 97 | TIME1 | Time | Time | TM6 | 6 | |
| 98 | RTCLCMTD | Rate Calculation Method | Integer | GB | 0 | |
| 99 | ORCTRXAM | Originating Current Trx Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 100 | OPURAMT | Originating Purchases Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 101 | ORFRTAMT | Originating Freight Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 102 | OMISCAMT | Originating Misc Charges Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 103 | ORTAXAMT | Originating Tax Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 104 | ORCASAMT | Originating Cash Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 105 | ORCHKAMT | Originating Check Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 106 | ORCHKTTL | Originating Check Total | Currency | DLR19_RBS0_UTR$ | 19 | |
| 107 | ORCCDAMT | Originating Credit Card Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 108 | ORAPPAMT | Originating Applied Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 109 | ORDISTKN | Originating Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 110 | ORDATKN | Originating Discount Available Taken | Currency | DLR17_RBS0_UTR$ | 17 | |
| 111 | ORDDLRAT | Originating Discount Dollar Amount | Currency | DLR11_RBS0_UTR$ | 11 | |
| 112 | ORTDISAM | Originating Trade Discount Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 113 | ORWROFAM | Originating Write Off Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 114 | OBKPURAMT | Originating Backout Purchases Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 115 | ORBKTFRT | Originating Backout Freight Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 116 | ORBKTMSC | Originating Backout Misc Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 117 | UNGANLOS | Unrealized Gain-Loss Amount | Currency | DLR19_$S2 | 19 | |
| 118 | RMMCERRS | RM MC Posting Error Messages | Long Integer | RM_MC_Posting_Error_Messages | 0 | |
| 119 | OCHGAMT | Originating Charge Amount | Currency | DLR19_RBSO_UTR$ | 19 | |
| 120 | ORDOCAMT | Originating Document Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 121 | ODISAMTAV | Originating Discount Amount Available | Currency | DLR17_RBS0_UTR$ | 17 | |
| 122 | ORGAPDISCTKN | Originating Applied Discount Taken Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 123 | OTOTPAY | Originating Total Payments | Currency | DLR19_RBS0_UTR$ | 19 | |
| 124 | OR1099AM | Originating 1099 Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 125 | DENXRATE | Denomination Exchange Rate | Currency (Variable) | DLR14_Exchange_Rate | 14 | |
| 126 | MCTRXSTT | MC Transaction State | Integer | INT1 | 1 | |
| 127 | VENDNAME | Vendor Name | String | STR64_Vendor_Name | 64 | |
| 128 | VNDCHKNM | Vendor Check Name | String | STR64_Vendor_Name | 64 | |
| 129 | VENDSHNM | Vendor Short Name | String | STR15 | 15 | |
| 130 | VADCDPAD | Vendor Address Code - Purchase Address | String | STR15_Address_Code | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['SmartList Payables Transactions'].VADCDPAD AS 'SmartList Payables Transactions-Vendor Address Code - Purchase Address'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList Payables Transactions'].VADCDPAD = ['PM Address MSTR'].ADRSCODE
AND
['SmartList Payables Transactions'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
| 131 | VADCDSFR | Vendor Address Code - Ship From | String | STR15_Address_Code | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['SmartList Payables Transactions'].VADCDSFR AS 'SmartList Payables Transactions-Vendor Address Code - Ship From'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList Payables Transactions'].VADCDSFR = ['PM Address MSTR'].ADRSCODE
AND
['SmartList Payables Transactions'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
| 132 | VADCDTRO | Vendor Address Code - Remit To | String | STR15_Address_Code | 15 | |
Partial key to the PM Address MSTR (PM00300).
Click to show/hideSELECT
['SmartList Payables Transactions'].VADCDTRO AS 'SmartList Payables Transactions-Vendor Address Code - Remit To'
,['PM Address MSTR'].ADRSCODE AS 'PM Address MSTR-Address Code'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
PM00300 AS ['PM Address MSTR']
ON
['SmartList Payables Transactions'].VADCDTRO = ['PM Address MSTR'].ADRSCODE
AND
['SmartList Payables Transactions'].VENDORID = ['PM Address MSTR'].VENDORID | ||||||
| 133 | VNDCLSID | Vendor Class ID | String | STR10_Class_ID | 10 | |
Key to the PM Class Master File (PM00100).
Click to show/hideSELECT
['SmartList Payables Transactions'].VNDCLSID AS 'SmartList Payables Transactions-Vendor Class ID'
,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
PM00100 AS ['PM Class Master File']
ON
['SmartList Payables Transactions'].VNDCLSID = ['PM Class Master File'].VNDCLSID | ||||||
| 134 | VNDCNTCT | Vendor Contact | String | STR60 | 60 | |
| 135 | ADDRESS1 | Address 1 | String | STR60 | 60 | |
| 136 | ADDRESS2 | Address 2 | String | STR60 | 60 | |
| 137 | ADDRESS3 | Address 3 | String | STR60 | 60 | |
| 138 | CITY | City | String | STR35 | 35 | |
| 139 | STATE | State | String | STR30_State | 29 | |
| 140 | ZIPCODE | Zip Code | String | STR10 | 10 | |
| 141 | COUNTRY | Country | String | STR60 | 60 | |
| 142 | PHNUMBR1 | Phone Number 1 | String | Phone_Number | 14 | |
| 143 | PHNUMBR2 | Phone Number 2 | String | Phone_Number | 14 | |
| 144 | FAXNUMBR | Fax Number | String | STR14_FAX | 14 | |
| 145 | UPSZONE | UPS Zone | String | STR3 | 3 | |
| 146 | ACNMVNDR | Account Number With Vendor | String | STR20 | 20 | |
| 147 | TXIDNMBR | Tax ID Number | String | Tax_ID_Number | 11 | |
| 148 | VENDSTTS | Vendor Status | Integer | DDL_Vendor_Status | 0 | |
| 149 | TXRGNNUM | Tax Registration Number | String | STR25 | 25 | |
| 150 | PARVENID | Parent Vendor ID | String | STR_15_Vendor_ID | 15 | |
| 151 | TRDDISCT | Trade Discount | Integer | INT4_%2 | 4 | |
| 152 | TEN99TYPE | 1099 Type | Integer | 1099_Type | 0 | |
| 153 | MINORDER | Minimum Order | Currency | DLR17_$U2 | 17 | |
| 154 | MINPYTYP | Minimum Payment Type | Integer | GB_Amt_Type | 0 | |
| 155 | MINPYPCT | Minimum Payment Percent | Integer | INT5_%2 | 5 | |
| 156 | MINPYDLR | Minimum Payment Dollar | Currency | DLR17_RBS0_UTR$ | 17 | |
| 157 | MXIAFVND | Maximum Invoice Amount For Vendors | Integer | GB | 0 | |
| 158 | MAXINDLR | Maximum Invoice Dollar | Currency | DLR17_$U2 | 17 | |
| 159 | COMMENT1 | Comment1 | String | STR30 | 30 | |
| 160 | COMMENT2 | Comment2 | String | STR30 | 30 | |
| 161 | USERDEF1 | User Defined 1 | String | STR20 | 20 | |
| 162 | USERDEF2 | User Defined 2 | String | STR20 | 20 | |
| 163 | CRLMTDLR | Credit Limit Dollar | Currency | DLR17_$U2 | 17 | |
| 164 | PYMNTPRI | Payment Priority | String | STR3 | 3 | |
| 165 | KPCALHST | Keep Calendar History | Boolean | CB_Keep_Calendar_History | 0 | |
| 166 | KGLDSTHS | Keep GL Dist History | Boolean | CB_Keep_GL_Dist_History | 0 | |
| 167 | KPERHIST | Keep Period History | Boolean | CB_Keep_Period_History | 0 | |
| 168 | KPTRXHST | Keep Trx History | Boolean | CB_Keep_Trx_History | 0 | |
| 169 | PTCSHACF | Post To Cash Account From | Integer | GB | 0 | |
| 170 | CREDTLMT | Credit Limit | Integer | GB | 0 | |
| 171 | WRITEOFF | Writeoff | Integer | GB | 0 | |
| 172 | MXWOFAMT | Maximum Write Off Amount | Currency | DLR17_$U2 | 17 | |
| 173 | SBPPSDED | Subject To PPS Deductions | Boolean | CB_Subject_To_PPS_Deductions | 0 | |
| 174 | DXVARNUM | Deduction Exemption/Variation Number | String | STR25 | 25 | |
| 175 | CRTCOMDT | Certificate Commencing Date | Date | DT | 8 | |
| 176 | CRTEXPDT | Certificate Expiration Date | Date | DT | 8 | |
| 177 | RTOBUTKN | Reporting Obligation Undertaken | Boolean | CB_Reporting_Obligation | 0 | |
| 178 | XPDTOBLG | Expiration Date Obligation | Boolean | CB_Expiration_Date_Obligation | 0 | |
| 179 | PRSPAYEE | Prescribed Payee | Boolean | CB_Prescribed_Payee | 0 | |
| 180 | PMAPINDX | PM AP Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].PMAPINDX AS 'SmartList Payables Transactions-PM AP Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].PMAPINDX = ['Account Index Master'].ACTINDX | ||||||
| 181 | PMCSHIDX | PM Cash Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].PMCSHIDX AS 'SmartList Payables Transactions-PM Cash Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].PMCSHIDX = ['Account Index Master'].ACTINDX | ||||||
| 182 | PMDAVIDX | PM Discount Available Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].PMDAVIDX AS 'SmartList Payables Transactions-PM Discount Available Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].PMDAVIDX = ['Account Index Master'].ACTINDX | ||||||
| 183 | PMDTKIDX | PM Discount Taken Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].PMDTKIDX AS 'SmartList Payables Transactions-PM Discount Taken Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].PMDTKIDX = ['Account Index Master'].ACTINDX | ||||||
| 184 | PMFINIDX | PM Finance Charge Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].PMFINIDX AS 'SmartList Payables Transactions-PM Finance Charge Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].PMFINIDX = ['Account Index Master'].ACTINDX | ||||||
| 185 | PMMSCHIX | PM Misc Charges Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].PMMSCHIX AS 'SmartList Payables Transactions-PM Misc Charges Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].PMMSCHIX = ['Account Index Master'].ACTINDX | ||||||
| 186 | PMFRTIDX | PM Freight Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].PMFRTIDX AS 'SmartList Payables Transactions-PM Freight Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].PMFRTIDX = ['Account Index Master'].ACTINDX | ||||||
| 187 | PMTAXIDX | PM Tax Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].PMTAXIDX AS 'SmartList Payables Transactions-PM Tax Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].PMTAXIDX = ['Account Index Master'].ACTINDX | ||||||
| 188 | PMWRTIDX | PM Write Offs Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].PMWRTIDX AS 'SmartList Payables Transactions-PM Write Offs Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].PMWRTIDX = ['Account Index Master'].ACTINDX | ||||||
| 189 | PMPRCHIX | PM Purchases Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].PMPRCHIX AS 'SmartList Payables Transactions-PM Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].PMPRCHIX = ['Account Index Master'].ACTINDX | ||||||
| 190 | PMRTNGIX | PM Retainage Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].PMRTNGIX AS 'SmartList Payables Transactions-PM Retainage Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].PMRTNGIX = ['Account Index Master'].ACTINDX | ||||||
| 191 | PMTDSCIX | PM Trade Discount Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].PMTDSCIX AS 'SmartList Payables Transactions-PM Trade Discount Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].PMTDSCIX = ['Account Index Master'].ACTINDX | ||||||
| 192 | ACPURIDX | Accrued Purchases Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].ACPURIDX AS 'SmartList Payables Transactions-Accrued Purchases Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].ACPURIDX = ['Account Index Master'].ACTINDX | ||||||
| 193 | PURPVIDX | Purchase Price Variance Index | Long Integer | LI_14 | 14 | |
Key to the Account Index Master (GL00105).
Click to show/hideSELECT
['SmartList Payables Transactions'].PURPVIDX AS 'SmartList Payables Transactions-Purchase Price Variance Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
ASIEXP09 AS ['SmartList Payables Transactions']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['SmartList Payables Transactions'].PURPVIDX = ['Account Index Master'].ACTINDX | ||||||
| 194 | Revalue_Vendor | Revalue Vendor | Boolean | CB Revalue Vendor | 0 | |
| 195 | Post_Results_To | Post Results To | Integer | GB | 0 | |
| 196 | FREEONBOARD | Free On Board | Integer | DDL_Free_On_Board | 0 | |
| 197 | HIESTBAL | Highest Balance | Currency | DLR17_RBS0_UTR$ | 17 | |
| 198 | CURRBLNC | Current Balance | Currency | DLR19_RBS0_STR$ | 19 | |
| 199 | NOINVYTD | Number of Invoices YTD | Long Integer | LI_9U0 | 9 | |
| 200 | NOINVLIF | Number of Invoices LIFE | Long Integer | LI_9U0 | 9 | |
| 201 | NOINVLYR | Number of Invoices LYR | Long Integer | LI_9U0 | 9 | |
| 202 | NOPINYTD | Number of Paid Invoices YTD | Long Integer | LI_9U0 | 9 | |
| 203 | NOPILIFE | Number of Paid Invoices LIFE | Long Integer | LI_9U0 | 9 | |
| 204 | AMBLDTYD | Amount Billed YTD | Currency | DLR19_RBS0_STR$ | 19 | |
| 205 | AMBLDLIF | Amount Billed LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 206 | AMBLDLYR | Amount Billed LYR | Currency | DLR19_RBS0_STR$ | 19 | |
| 207 | AMTPDYTD | Amount Paid YTD | Currency | DLR19_RBS0_STR$ | 19 | |
| 208 | AMTPDLYR | Amount Paid LYR | Currency | DLR19_RBS0_STR$ | 19 | |
| 209 | AMTPDLIF | Amount Paid LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 210 | TEN99ALIF | 1099 Amount LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 211 | TEN99ALYR | 1099 Amount LYR | Currency | DLR19_RBS0_STR$ | 19 | |
| 212 | TEN99AYTD | 1099 Amount YTD | Currency | DLR19_RBS0_STR$ | 19 | |
| 213 | DISAVYTD | Discount Available YTD | Currency | DLR19_RBS0_STR$ | 19 | |
| 214 | DISAVLIF | Discount Available LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 215 | DISAVLYR | Discount Available LYR | Currency | DLR19_RBS0_STR$ | 19 | |
| 216 | DISTKYTD | Discount Taken YTD | Currency | DLR19_RBS0_STR$ | 19 | |
| 217 | DISTKNLF | Discount Taken LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 218 | DISTKLYR | Discount Taken LYR | Currency | DLR19_RBS0_STR$ | 19 | |
| 219 | DISLSYTD | Discount Lost YTD | Currency | DLR19_RBS0_STR$ | 19 | |
| 220 | DISLSTLF | Discount Lost LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 221 | DISLSLYR | Discount Lost LYR | Currency | DLR19_RBS0_STR$ | 19 | |
| 222 | FINCHLIF | Finance Charge LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 223 | FINCHLYR | Finance Charge LYR | Currency | DLR19_RBS0_STR$ | 19 | |
| 224 | FINCHYTD | Finance Charge YTD | Currency | DLR19_RBS0_STR$ | 19 | |
| 225 | WROFSLIF | Write Offs LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 226 | WROFSLYR | Write Offs LYR | Currency | DLR19_RBS0_STR$ | 19 | |
| 227 | WROFSYTD | Write Offs YTD | Currency | DLR19_RBS0_STR$ | 19 | |
| 228 | RTRNSLIF | Returns LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 229 | RTRNSLYR | Returns LYR | Currency | DLR19_RBS0_STR$ | 19 | |
| 230 | RTRNSYTD | Returns YTD | Currency | DLR19_RBS0_STR$ | 19 | |
| 231 | TRDTKLIF | Trade Discounts Taken LIFE | Currency | DLR19_RBSO_STR$ | 19 | |
| 232 | TRDTLYR | Trade Discounts Taken LYR | Currency | DLR19_RBSO_STR$ | 19 | |
| 233 | TRDTYTD | Trade Discounts Taken YTD | Currency | DLR19_RBSO_STR$ | 19 | |
| 234 | NFNCHLIF | Number of Finance Charges LIFE | Long Integer | LI_9U0 | 9 | |
| 235 | NFNCHLYR | Number of Finance Charges LYR | Long Integer | LI_9U0 | 9 | |
| 236 | NFNCHYTD | Number of Finance Charges YTD | Long Integer | LI_9U0 | 9 | |
| 237 | RTNGOWED | Retainage Owed | Currency | DLR17_RBS0_STR$ | 17 | |
| 238 | LSTCHNUM | Last Check Number | String | Check_Number | 20 | |
| 239 | LSTCHKDT | Last Check Date | Date | DT | 8 | |
| 240 | LSTCHAMT | Last Check Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 241 | LSTINNUM | Last Invoice Number | String | STR20 | 20 | |
| 242 | LSTINVAM | Last Invoice Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 243 | LSTPURDT | Last Purchase Date | Date | DT | 8 | |
| 244 | FSTPURDT | First Purchase Date | Date | DT | 8 | |
| 245 | CURUNPBN | Current Unapplied Payment Balance | Currency | DLR17_RBS0_UTR$ | 17 | |
| 246 | UNPDFNCH | Unpaid Finance Charges | Currency | DLR17_RBS0_UTR$ | 17 | |
| 247 | DYCHTCLR | Days Checks To Clear | Integer | INT3_U0 | 3 | |
| 248 | AVGDTPYR | Average Days To Pay - Year | Integer | INT3_U0 | 3 | |
| 249 | AVDTPLIF | Average Days To Pay - Life | Integer | INT3_U0 | 3 | |
| 250 | ACCRDINV | Accured Inventory | Currency | DLR17_RBS0_STR$ | 17 | |
| 251 | ONORDAMT | On Order Amount | Currency | DLR19_RBS0_UTR$ | 19 | |
| 252 | DISGRPER | Discount Grace Period | Integer | INT2_U0 | 2 | |
| 253 | DOCFMTID | Document Format ID | String | STR15_LBU | 15 | |
| 254 | DUEGRPER | Due Date Grace Period | Integer | INT2_U0 | 2 | |
| 255 | GOVCRPID | Governmental Corporate ID | String | STR30_Gov_Corp_ID | 30 | |
| 256 | GOVINDID | Governmental Individual ID | String | STR30_Gov_Indiv_ID | 30 | |
| 257 | PHONE3 | Phone 3 | String | Phone_Number3 | 14 | |
| 258 | TaxInvRecvd | Tax Invoice Received | Boolean | CB_Tax_Invoice_Received | 0 | |
| 259 | Withholding_LIFE | Withholding LIFE | Currency | DLR19_RBS0_STR$ | 19 | |
| 260 | WITHLYR | Withholding LYR | Currency | DLR19_RBS0_STR$ | 19 | |
| 261 | WITHYTD | Withholding YTD | Currency | DLR19_RBS0_STR$ | 19 | |
| 262 | APLYWITH | Apply Withholding | Boolean | Boolean | 0 | |
| 263 | CORRCTN | Correction | Boolean | CB_Correction | 0 | |
| 264 | DocPrinted | DocPrinted | Boolean | CB_DocPrinted | 0 | |
Click to show/hide Document Printed flag
0 Record has not been printed.
1 Record has been printed. | ||||||
| 265 | 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. | ||||||
| 266 | Electronic | Electronic | Boolean | CB_Electronic | 0 | |
| 267 | PRCHDATE | Purchase Date | Date | DT | 8 | |
| 268 | SIMPLIFD | Simplified | Boolean | CB_Simplified | 0 | |
| 269 | TaxInvReqd | Tax Invoice Required | Boolean | CB_Tax_Invoice_Required | 0 | |
| 270 | BNKRCAMT | Bank Receipts Amount | Currency | DLR17_RBS0_STR$ | 17 | |
| 271 | CORRNXST | Correction to Nonexisting Transaction | Boolean | Boolean | 0 | |
| 272 | PMWRKMS2 | PM WORK Messages 2 | Long Integer | ML_PM_WORK_Messages_2 | 0 | |
| 273 | VCHRNCOR | Voucher Number Corrected | String | STR20_LBAU | 20 | |
| 274 | VNDCHKNM1 | ASI_Vendor_Check_Name | String | STR64_Vendor_Name | 64 | |
| 275 | VADDCDPR1 | ASI_Vendor_Address_Code_Primary | String | STR15_Address_Code | 15 | |
| 276 | PYMTRMID1 | ASI_Payment_Terms_ID | String | STR20_Payment_Terms_ID | 20 | |
| 277 | SHIPMTHD1 | ASI_Shipping_Method | String | STR15_Shipping_Method | 15 | |
| 278 | TAXSCHID1 | ASI_Tax_Schedule_ID | String | STR15_Tax_Schedule_ID | 15 | |
| 279 | CURNCYID1 | ASI_Currency_ID | String | STR15_Currency_ID | 15 | |
| 280 | HOLD1 | ASI_Hold | Boolean | CB_Hold | 0 | |
| 281 | PPSTAXRT1 | ASI_PPS_Tax_Rate | Integer | INT5_%2 | 5 | |
| 282 | NOTEINDX1 | ASI_Note_Index | Currency | DLR14 | 14 | |
| 283 | CHEKBKID1 | ASI_Checkbook_ID | String | STR15_Checkbook_ID | 15 | |
| 284 | MODIFDT1 | ASI_Modified_Date | Date | DT | 8 | |
| 285 | CREATDDT1 | ASI_Created_Date | Date | DT | 8 | |
| 286 | RATETPID1 | ASI_Rate_Type_ID | String | STR15_Rate_Type_ID | 15 | |
| 287 | TaxInvRecvd1 | ASI_Tax_Invoice_Received | Boolean | CB_Tax_Invoice_Received | 0 | |
| 288 | VADCDTRO1 | ASI_Vendor_Address_Code_Remit_To | String | STR15_Address_Code | 15 | |