Table 4060 "GPPOPReceiptApply"

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	PONUMBER	text[18]	PO Number caption
2	POLNENUM	Integer	PO Line Number caption
3	POPRCTNM	text[18]	POP Receipt Number caption
4	RCPTLNNM	Integer	Receipt Line Number caption
5	QTYSHPPD	Decimal	Quantity Shipped caption
6	QTYINVCD	Decimal	Quantity Invoiced caption
7	QTYREJ	Decimal	Quantity Rejected caption
8	QTYMATCH	Decimal	Quantity Matched caption
9	QTYRESERVED	Decimal	Quantity Reserved caption
10	QTYINVRESERVE	Decimal	Quantity Invoice Reserve caption
11	Status	Option	—
12	UMQTYINB	Decimal	U Of M QTY In Base caption
13	OLDCUCST	Decimal	Old Current Cost caption
14	JOBNUMBR	text[18]	Job Number caption
15	COSTCODE	text[28]	Cost Code caption
16	COSTTYPE	Integer	Cost Code Type caption
17	ORCPTCOST	Decimal	Originating Receipt Cost caption
18	OSTDCOST	Decimal	Originating Standard Cost caption
19	APPYTYPE	Option	Apply Type caption
20	POPTYPE	Option	POP Type caption
21	VENDORID	text[16]	Vendor ID caption
22	ITEMNMBR	text[32]	Item Number caption
23	UOFM	text[10]	U Of M caption
24	TRXLOCTN	text[12]	TRX Location caption
25	DATERECD	Date	Date Received caption
26	RCTSEQNM	Integer	Receipt SEQ Number caption
27	SPRCTSEQ	Integer	Split Receipt SEQ Number caption
28	PCHRPTCT	Decimal	Purchase Receipt Cost caption
29	SPRCPTCT	Decimal	Split Receipt Cost caption
30	OREXTCST	Decimal	Originating Extended Cost caption
31	RUPPVAMT	Decimal	Remaining UPPV Amount caption
32	ACPURIDX	Integer	Accrued Purchases Index caption
33	INVINDX	Integer	Inventory Index caption
34	UPPVIDX	Integer	Unrealized Purchase Price Variance Index caption
35	NOTEINDX	Decimal	Note Index caption
36	CURNCYID	text[16]	Currency ID caption
37	CURRNIDX	Integer	Currency Index caption
38	XCHGRATE	Decimal	Exchange Rate caption
39	RATECALC	Option	Rate Calc Method caption
40	DENXRATE	Decimal	Denomination Exchange Rate caption
41	RATETPID	text[16]	Rate Type ID caption
42	EXGTBLID	text[16]	Exchange Table ID caption
43	Capital_Item	Boolean	Capital Item caption
44	Product_Indicator	Integer	Product Indicator caption
45	Total_Landed_Cost_Amount	Decimal	Total Landed Cost Amount caption
46	QTYTYPE	Option	QTY Type caption
47	Posted_LC_PPV_Amount	Decimal	Posted LC PPV Amount caption
48	QTYREPLACED	Decimal	Quantity Replaced caption
49	QTYINVADJ	Decimal	Quantity Invoice Adjustment caption
50	DEX_ROW_ID	Integer	—

Keys

PK: POPRCTNM, RCPTLNNM, PONUMBER, POLNENUM
Key2: POPRCTNM, RCPTLNNM
Key3: TRXLOCTN, PCHRPTCT

Procedures

GetSumQtyShippedByUnitCost(PO_Number: Text[18]; PO_LineNo: Integer; Location: Text[12]; UnitCost: Decimal): Decimal
GetSumQtyInvoicedByUnitCost(PO_Number: Text[18]; PO_LineNo: Integer; Location: Text[12]; UnitCost: Decimal): Decimal

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: "GPPOPReceiptApply"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.