CFM30000 - CFM_SOPDueDateQuote
Dynamics GP table CFM30000 (CFM_SOPDueDateQuote) contains 7 columns including CUSTNMBR, SOPNUMBE, SOPTYPE....
SQL Query Builder
7 Columns
| Column | Description | Type | Length | ||
|---|---|---|---|---|---|
| CUSTNMBR | Customer Number | String | 16 | ||
| SOPNUMBE | SOP Number | String | 22 | ||
| SOPTYPE | SOP Type1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order (In SBF, this value is not available.) | Integer | 2 | ||
SOP Document Type values (6) 1 = Quote2 = Order3 = Invoice4 = Return5 = Back Order6 = Fulfillment Order | |||||
| DOCDATE | Document Date | Date | 4 | ||
| DUEDATE | Due Date | Date | 4 | ||
| Amount | Amount | Currency | 10 | ||
| AMNTPAID | Amount Paid | Currency | 10 | ||
Related Tables
Tables that share columns with CFM30000. Click "Join" to add to your query.
Amount