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	66 tables
SEQNUMBR	Sequence Number	Long Integer	4	86 tables
APTODCTY	Apply To Document Type	Integer	2	17 tables
APTODCNM	Apply To Document Number	String	22	11 tables
APPTOAMT	Apply To Amount	Currency	10	5 tables
CUSTNMBR	Customer Number	String	16	230 tables
CUSTNAME	Customer Name	String	66	41 tables

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

CUSTNMBR

SEQNUMBR

DOCNUMBR

APTODCTY

APTODCNM

APPTOAMT