IVC50100 - Invoicing Document Header Temp
Dynamics GP table IVC50100 (Invoicing Document Header Temp) contains 5 columns including Restrict_Type, DOCTYPE, INVCNMBR....
SQL Query Builder
5 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| Restrict_Type | Restrict Type | Integer | 2 | ||
| DOCTYPE | Document Type | Integer | 2 | ||
Document Type (Payables) values (7) 1 = Invoice2 = Finance Charge3 = Miscellaneous Charge4 = Return5 = Credit Memo6 = Payment7 = Scheduled Payment | |||||
| INVCNMBR | Invoice Number | String | 22 | ||
| USERID | User ID | String | 16 | ||
| SEQNUMBR | Sequence Number | Long Integer | 4 | ||
Related Tables
Tables that share columns with IVC50100. Click "Join" to add to your query.