GP Tables

IVC10100 - Invoicing Transaction Work

Dynamics GP table IVC10100 (Invoicing Transaction Work) contains 106 columns including DOCTYPE, INVCNMBR, BACHNUMB....

SQL Query Builder

106 Columns

Column Description Type Length
DOCTYPE Document Type Integer 2
Document Type (Payables) values (7)
1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment
INVCNMBR Invoice Number String 22
BACHNUMB Batch Number String 16
BCHSOURC Batch Source String 16
PCKSLPNO Packing Slip Number String 22
CUSTNMBR Customer Number String 16
CUSTNAME Customer Name String 66
CSTPONBR Customer PO Number String 22
POSTDATE Post Date Date 4
GLPOSTDT GL Posting Date Date 4
DOCDATE Document Date Date 4
QUOTEDAT Quote Date Date 4
ORDRDATE Order Date Date 4
DISCDATE Discount Date Date 4
DUEDATE Due Date Date 4
HOLDNT Hold NT Boolean 2
SHIPMTHD Shipping Method String 16
TAXEXMT1 Tax Exempt 1 String 26
TAXEXMT2 Tax Exempt 2 String 26
TAXSCHID Tax Schedule ID String 16
FRTSCHID Freight Schedule ID String 16
FRGTTXBL Freight Taxable1 = Taxable2 = Nontaxable3 = Base on customers Integer 2
FRTTXAMT Freight Tax Amount Currency 10
MSCSCHID Misc Schedule ID String 16
MISCTXBL Misc Taxable1 = Taxable2 = Nontaxable3 = Base on customers Integer 2
MSCTXAMT Misc Tax Amount Currency 10
SLPRSNID Salesperson ID String 16
SALSTERR Sales Territory String 16
TXRGNNUM Tax Registration Number String 26
PYMTRMID Payment Terms ID String 22
PRCLEVEL PriceLevel String 12
LOCNCODE Location Code String 12
CURNCYID Currency ID Functional currency code (e.g., USD, CAD, GBP). Use to filter or group multicurrency transactions. String 16
COMMNTID Comment ID String 16
DOCAMNT Document Amount Currency 10
SUBTOTAL Subtotal Currency 10
FRTAMNT Freight Amount Currency 10
MISCAMNT Misc Amount Currency 10
TAXAMNT Tax Amount Currency 10
TXBTXAMT Taxable Tax Amount Currency 10
BCKTXAMT Backout Tax Amount Currency 10
BKTSLSAM Backout Sales Amount Currency 10
BKTFRTAM Backout Freight Amount Currency 10
BKTMSCAM Backout Misc Amount Currency 10
DISCFRGT Discount Available Freight Currency 10
DISCMISC Discount Available Misc Currency 10
TRDISPCT Trade Discount Percent Integer 2
TRDISAMT Trade Discount Amount Currency 10
ACCTAMNT Account Amount Currency 10
PYMTRCVD Payment Received Currency 10
CODAMNT COD Amount Currency 10
EXTDCOST Extended Cost Currency 10
DISCRTND Discount Returned Currency 10
DISAVTKN Discount Available Taken Currency 10
DISTKNAM Discount Taken Amount Currency 10
DISAVAMT Discount Available Amount Currency 10
DSCDLRAM Discount Dollar Amount Currency 10
DSCPCTAM Discount Percent Amount Integer 2
MRKDNAMT Markdown Amount Currency 10
PRBTADCD Primary Billto Address Code String 16
PRSTADCD Primary Shipto Address Code String 16
CNTCPRSN Contact Person String 62
ADDRESS1 Address 1 String 62
ADDRESS2 Address 2 String 62
ADDRESS3 Address 3 String 62
CITY City String 36
STATE State String 30
ZIPCODE Zip Code String 12
CCode Country Code String 8
COUNTRY Country String 62
PHNUMBR1 Phone Number 1 String 22
PHNUMBR2 Phone Number 2 String 22
PHONE3 Phone 3 String 22
FAXNUMBR Fax Number String 22
COMAPPTO Commission Applied To Integer 2
COMDLRAM Commission Dollar Amount Currency 10
NCOMAMNT Non-Commissioned Amount Currency 10
UPSZONE UPS Zone String 4
LSTUSRED Last User to Edit String 16
LSTEDTDT Last Edit Date Date 4
MODIFDT Modified Date Date 4
CREATDDT Created Date Date 4
USER2ENT User To Enter String 16
NOTEINDX Note Index Currency 10
TIMESPRT Times Printed Integer 2
NOCARTNS Number Of Cartons Integer 2
USERDEF1 User Defined 1 String 22
USERDEF2 User Defined 2 String 22
VOIDSTTS Void Status0 = Document has not been voided.1 = Document has been voided.2 = Document has been marked NSF and voided. Integer 2
Void Status values (2)
0 = Normal1 = Voided
TRXSORCE TRX Source String 14
PSTGSTUS Posting Status1 = Work2 = Open3 = History4 = Originating Integer 2
Posting Status values (11)
0 = Unposted / New1 = Unposted / Work2 = Posted / Open3 = History / Posted with Error10 = First entry before save20 = Saved and unposted30 = Currently posting40 = Posted50 = Error during posting60 = Edited after save70 = Edited recurring batch
IVCHDER1 IVC HDR Errors 1 Long Integer 4
IVCHDER2 IVC HDR Errors 2 Long Integer 4
IVCLINEERR IVC LINE Errors Long Integer 4
LNITMSEQ Line Item Sequence Long Integer 4
COMMENT_1 Comment[1] String 52
COMMENT_2 Comment[2] String 52
COMMENT_3 Comment[3] String 52
COMMENT_4 Comment[4] String 52
ECTRX EC Transaction Boolean 2
ShipToName ShipToName String 66
Tax_Date Tax Date Date 4
APLYWITH Apply Withholding Boolean 2
WITHHAMT Withholding Amount Currency 10
BackoutTradeDisc Backout Trade Discount Amount Currency 10
CMMTTEXT Comment Text Text 2

Related Tables

Tables that share columns with IVC10100. Click "Join" to add to your query.

NOTEINDX

AAG00400 AAG00401 AF40100 AF40103 AF40106 ASIEXP01 ASIEXP02 ASIEXP03

CURNCYID

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 AAG50001 AAG60001

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

LNITMSEQ

ASIEXP20 ASIEXP25 ASIEXP26 DO10100 EDCEI006 EEPAIVRQ ERB10300 ERB10700

TRXSORCE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP18 ASIEXP19

BACHNUMB

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25

DOCDATE

ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP21

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

DISTKNAM

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP20 ASIEXP25 ICJC9000 ICJC9001 IVC30101

BCHSOURC

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25 ASIEXP27