Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP10206
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: Sales Bulk Print Header Group Display Name: Sales Distribution
Physical Name: SOP10206
Technical Name: sopBulkPrintHdr
Group Technical Name: Sales Distribution
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
2 | LOCNCODE | Location Code | String | STR10_Location_Code | 10 | |
Key to the Site Setup (IV40700).
Click to show/hideSELECT
['Sales Bulk Print Header'].LOCNCODE AS 'Sales Bulk Print Header-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
SOP10206 AS ['Sales Bulk Print Header']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['Sales Bulk Print Header'].LOCNCODE = ['Site Setup'].LOCNCODE | ||||||
3 | SEQNUMBR | Sequence Number | Long Integer | LI_Sequence_Number | 10 | |
4 | Bulk_Print_Date | Bulk Print Date | Date | DATE | 6 | |
5 | TIMESPRT | Times Printed | Integer | INT4_U0 | 4 |