GP Tables

POP11300 - POP PA Receipt View

Dynamics GP table POP11300 (POP PA Receipt View) contains 55 columns including POPRCTNM, POPHDR3, CASHAMNT....

SQL Query Builder

55 Columns

Column Description Type Length
POPRCTNM POP Receipt Number String 18
POPHDR3 POP HDR Errors 3 Long Integer 4
CASHAMNT Cash Amount Currency 10
ORCASAMT Originating Cash Amount Currency 10
CHEKAMNT Check Amount Currency 10
ORCHKAMT Originating Check Amount Currency 10
CRCRDAMT Credit Card Amount Currency 10
ORCCDAMT Originating Credit Card Amount Currency 10
DISTKNAM Discount Taken Amount Currency 10
ORDISTKN Originating Discount Taken Amount Currency 10
Array_of_Strings_1 Array of Strings[1] String 32
Array_of_Strings_2 Array of Strings[2] String 32
Array_of_Strings_3 Array of Strings[3] String 32
Array_of_Strings_4 Array of Strings[4] String 32
Array_of_Strings_5 Array of Strings[5] String 32
Array_of_Strings_6 Array of Strings[6] String 32
Array_of_Strings_7 Array of Strings[7] String 32
Array_of_Strings_8 Array of Strings[8] String 32
Array_of_Strings_9 Array of Strings[9] String 32
Array_of_Strings_10 Array of Strings[10] String 32
Array_of_Strings_11 Array of Strings[11] String 32
Array_of_Strings_12 Array of Strings[12] String 32
Array_of_Strings_13 Array of Strings[13] String 32
Array_of_Strings_14 Array of Strings[14] String 32
Array_of_Strings_15 Array of Strings[15] String 32
Array_of_Strings_16 Array of Strings[16] String 32
Array_of_Strings_17 Array of Strings[17] String 32
Array_of_Strings_18 Array of Strings[18] String 32
Array_of_Strings_19 Array of Strings[19] String 32
Array_of_Strings_20 Array of Strings[20] String 32
Array_of_Dollars_1 Array of Dollars[1] Currency 10
Array_of_Dollars_2 Array of Dollars[2] Currency 10
Array_of_Dollars_3 Array of Dollars[3] Currency 10
Array_of_Dollars_4 Array of Dollars[4] Currency 10
Array_of_Dollars_5 Array of Dollars[5] Currency 10
Array_of_Dollars_6 Array of Dollars[6] Currency 10
Array_of_Dollars_7 Array of Dollars[7] Currency 10
Array_of_Dollars_8 Array of Dollars[8] Currency 10
Array_of_Dollars_9 Array of Dollars[9] Currency 10
Array_of_Dollars_10 Array of Dollars[10] Currency 10
Array_of_Dollars_11 Array of Dollars[11] Currency 10
Array_of_Dollars_12 Array of Dollars[12] Currency 10
Array_of_Dollars_13 Array of Dollars[13] Currency 10
Array_of_Dollars_14 Array of Dollars[14] Currency 10
Array_of_Dollars_15 Array of Dollars[15] Currency 10
Array_of_Dollars_16 Array of Dollars[16] Currency 10
Array_of_Dollars_17 Array of Dollars[17] Currency 10
Array_of_Dollars_18 Array of Dollars[18] Currency 10
Array_of_Dollars_19 Array of Dollars[19] Currency 10
Array_of_Dollars_20 Array of Dollars[20] Currency 10
Array_of_Texts_1 Array of Texts[1] Text 2
Array_of_Texts_2 Array of Texts[2] Text 2
Array_of_Texts_3 Array of Texts[3] Text 2
Array_of_Texts_4 Array of Texts[4] Text 2
Array_of_Texts_5 Array of Texts[5] Text 2

Related Tables

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

DISTKNAM

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP20 ASIEXP25 ICJC9000 ICJC9001 IVC10100

ORDISTKN

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP20 MC020102 MC020103 PA10500 PA10701

CASHAMNT

ASIEXP08 ASIEXP09 ICJC9000 ICJC9001 PA10500 PA10701 PA11800 PA13100

CHEKAMNT

ASIEXP08 ASIEXP09 ICJC9000 ICJC9001 ME142805 PA10500 PA10701 PA11800

CRCRDAMT

ASIEXP08 ASIEXP09 ICJC9000 ICJC9001 PA10500 PA10701 PA11800 PA13100

ORCASAMT

ASIEXP08 ASIEXP09 MC020102 MC020103 PA10500 PA10701 PA13100 PA23100

ORCHKAMT

ASIEXP08 ASIEXP09 MC020102 MC020103 PA10500 PA10701 PA13100 PA23100

ORCCDAMT

ASIEXP08 ASIEXP09 MC020102 MC020103 PA10500 PA10701 PA13100 PA23100

POPRCTNM

ASIEXP27 ASIEXP28 POP10300 POP10306 POP30300 POP31300 POR10310

Array_of_Strings_1

POP31300