Table 4061 "GPPOPReceiptHist"

HybridGP · Microsoft.DataMigration.GP · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Extensible	false
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation
1	POPRCTNM	text[18]	POP Receipt Number caption
2	POPTYPE	Option	POP Type caption
3	VNDDOCNM	text[22]	Vendor Document Number caption
4	receiptdate	Date	Receipt Date caption
5	GLPOSTDT	Date	GL Posting Date caption
6	ACTLSHIP	Date	Actual Ship Date caption
7	BCHSOURC	text[16]	Batch Source caption
8	BACHNUMB	text[16]	Batch Number caption
9	VENDORID	text[16]	Vendor ID caption
10	VENDNAME	text[66]	Vendor Name caption
11	SUBTOTAL	Decimal	Subtotal caption
12	TRDISAMT	Decimal	Trade Discount Amount caption
14	FRTAMNT	Decimal	Freight Amount caption
15	MISCAMNT	Decimal	Misc Amount caption
16	TAXAMNT	Decimal	Tax Amount caption
17	TEN99AMNT	Decimal	1099 Amount caption
18	PYMTRMID	text[22]	Payment Terms ID caption
19	DSCPCTAM	Integer	Discount Percent Amount caption
20	DSCDLRAM	Decimal	Discount Dollar Amount caption
21	DISAVAMT	Decimal	Discount Available Amount caption
22	DISCDATE	Date	Discount Date caption
23	DUEDATE	Date	Due Date caption
24	REFRENCE	text[32]	Reference caption
25	VOIDSTTS	Option	Void Status caption
26	RCPTNOTE_1	Decimal	Receipt Note ID Array 1 caption
27	RCPTNOTE_2	Decimal	Receipt Note ID Array 2 caption
28	RCPTNOTE_3	Decimal	Receipt Note ID Array 3 caption
29	RCPTNOTE_4	Decimal	Receipt Note ID Array 4 caption
30	RCPTNOTE_5	Decimal	Receipt Note ID Array 5 caption
31	RCPTNOTE_6	Decimal	Receipt Note ID Array 6 caption
32	RCPTNOTE_7	Decimal	Receipt Note ID Array 7 caption
33	RCPTNOTE_8	Decimal	Receipt Note ID Array 8 caption
34	POSTEDDT	Date	Posted Date caption
35	PTDUSRID	text[16]	Posted User ID caption
36	USER2ENT	text[16]	User To Enter caption
37	CREATDDT	Date	Created Date caption
38	MODIFDT	Date	Modified Date caption
39	TRXSORCE	text[14]	TRX Source caption
40	VCHRNMBR	text[22]	Voucher Number caption
41	Tax_Date	Date	Tax Date caption
42	CURNCYID	text[16]	Currency ID caption
43	CURRNIDX	Integer	Currency Index caption
44	RATETPID	text[16]	Rate Type ID caption
45	EXGTBLID	text[16]	Exchange Table ID caption
46	XCHGRATE	Decimal	Exchange Rate caption
47	EXCHDATE	Date	Exchange Date caption
48	TIME1	DateTime	Time caption
49	RATECALC	Option	Rate Calc Method caption
50	DENXRATE	Decimal	Denomination Exchange Rate caption
51	MCTRXSTT	Option	MC Transaction State caption
52	ORSUBTOT	Decimal	Originating Subtotal caption
53	ORTDISAM	Decimal	Originating Trade Discount Amount caption
54	ORFRTAMT	Decimal	Originating Freight Amount caption
55	ORMISCAMT	Decimal	Originating Misc Amount caption
56	ORTAXAMT	Decimal	Originating Tax Amount caption
57	OR1099AM	Decimal	Originating 1099 Amount caption
58	ORDDLRAT	Decimal	Originating Discount Dollar Amount caption
59	ORDAVAMT	Decimal	Originating Discount Available Amount caption
60	SIMPLIFD	Boolean	Simplified caption
61	WITHHAMT	Decimal	Withholding Amount caption
62	ECTRX	Boolean	EC Transaction caption
63	TXRGNNUM	text[26]	Tax Registration Number caption
64	TAXSCHID	text[16]	Tax Schedule ID caption
65	BSIVCTTL	Boolean	Based On Invoice Total caption
66	Purchase_Freight_Taxable	Option	Purchase Freight Taxable caption
67	Purchase_Misc_Taxable	Option	Purchase Misc Taxable caption
68	FRTSCHID	text[16]	Freight Schedule ID caption
69	MSCSCHID	text[16]	Misc Schedule ID caption
70	FRTTXAMT	Decimal	Freight Tax Amount caption
71	ORFRTTAX	Decimal	Originating Freight Tax Amount caption
72	MSCTXAMT	Decimal	Misc Tax Amount caption
73	ORMSCTAX	Decimal	Originating Misc Tax Amount caption
74	BCKTXAMT	Decimal	Backout Tax Amount caption
75	OBTAXAMT	Decimal	Originating Backout Tax Amount caption
76	TaxInvReqd	Boolean	Tax Invoice Required caption
77	BackoutFreightTaxAmt	Decimal	Backout Freight Tax Amount caption
78	OrigBackoutFreightTaxAmt	Decimal	Originating Backout Freight Tax Amount caption
79	BackoutMiscTaxAmt	Decimal	Backout Misc Tax Amount caption
80	OrigBackoutMiscTaxAmt	Decimal	Originating Backout Misc Tax Amount caption
81	TaxInvRecvd	Boolean	Tax Invoice Received caption
82	APLYWITH	Boolean	Apply Withholding caption
83	PPSTAXRT	Integer	PPS Tax Rate caption
84	SHIPMTHD	text[16]	Shipping Method caption
85	Total_Landed_Cost_Amount	Decimal	Total Landed Cost Amount caption
86	CBVAT	Boolean	Cash Based VAT caption
87	VADCDTRO	text[16]	Vendor Address Code - Remit To caption
88	REVALJRNENTRY	Integer	Revaluation Journal Entry caption
89	REVALTRXSOURCE	text[14]	Revaluation TRX Source caption
90	TEN99TYPE	Option	1099 Type caption
91	TEN99BOXNUMBER	Integer	1099 Box Number caption
92	REPLACEGOODS	Boolean	Replace Returned Goods caption
93	INVOICEEXPECTED	Boolean	Invoice Expected Returns caption
94	PrepaymentAmount	Decimal	Prepayment Amount caption
95	OriginatingPrepaymentAmt	Decimal	Originating Prepayment Amount caption
96	DISTKNAM	Decimal	Discount Taken Amount caption
97	ORDISTKN	Decimal	Originating Discount Taken Amount caption
98	DISAVTKN	Decimal	Discount Available Taken caption
99	ORDATKN	Decimal	Originating Discount Available Taken caption
100	InvoiceReceiptDate	Date	Invoice Receipt Date caption
101	Workflow_Status	Option	Workflow Status caption
102	DEX_ROW_ID	Integer	—

Keys

PK: POPRCTNM
Key2: DEX_ROW_ID
Key3: PYMTRMID

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "GPPOPReceiptHist"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.