palbInvc - Lockbox Invoice Work

Dynamics GP table palbInvc (Lockbox Invoice Work) contains 7 columns including DOCNUMBR, SEQNUMBR, APTODCTY....

SQL Query Builder

SELECT * FROM palbInvc

Select all

Column	Description	Type	Length	Shared With
DOCNUMBR	Document Number	String	22	41 tables
SEQNUMBR	Sequence Number	Long Integer	4	30 tables
APTODCTY	Apply To Document Type	Integer	2	17 tables
APTODCNM	Apply To Document Number	String	22	9 tables
APPTOAMT	Apply To Amount	Currency	10	3 tables
CUSTNMBR	Customer Number	String	16	70 tables
CUSTNAME	Customer Name	String	66	21 tables

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

CUSTNMBR

APTODCTY

APTODCNM

APPTOAMT