GP Tables

IVC30101 - Invoicing Transaction History

Dynamics GP table IVC30101 (Invoicing Transaction History) contains 94 columns including DOCTYPE, INVCNMBR, BACHNUMB....

SQL Query Builder

94 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
MRKDNAMT Markdown 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
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
DISAVTKN Discount Available Taken Currency 10
DISCRTND Discount Returned 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
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
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
CMMTTEXT Comment Text Text 2

Related Tables

Tables that share columns with IVC30101. 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 IVC10100

BCHSOURC

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25 ASIEXP27