Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/palbmstr
Product: Microsoft Dynamics GP (0)
Series: Sales
Display Name: Lockbox Master Group Display Name: Lockbox Setup
Physical Name: palbmstr
Technical Name: paLockboxMSTR
Group Technical Name: Lockbox Setup
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | LockboxID  | paLockboxID | String | STR15_LBAU | 15 | |
| 2 | LockboxDescription | paLockboxDescription | String | STR30 | 30 | |
| 3 | paLockboxFormatType | paLockboxFormatType | Integer | paLockboxFormatType | 0 | |
| 4 | STRGA255 | String A 255 | String | STR255 | 255 | |
| 5 | LockboxFileName | paLockboxFileName | String | STR60 | 60 | |
| 6 | XPRTFTYP | Export File Type | Integer | DDL_Export_File_Type | 0 | |
| 7 | CHEKBKID | Checkbook ID | String | STR15_Checkbook_ID | 15 | |
Key to the CM Checkbook Master (CM00100).
Click to show/hideSELECT
['Lockbox Master'].CHEKBKID AS 'Lockbox Master-Checkbook ID'
,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID'
FROM
palbmstr AS ['Lockbox Master']
INNER JOIN
CM00100 AS ['CM Checkbook Master']
ON
['Lockbox Master'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID | ||||||
| 8 | paApplyMethod | paApplyMethod | Integer | paApplyMethod | 0 | |
| 9 | paApplyMethodInvoice | paApplyMethodInvoice | Integer | paDDL_ApplyMethodInvoice | 0 | |
| 10 | DECPLCUR | Decimal Places Currency | Integer | DDL_Decimal_Places_Dollars | 0 | |
| 11 | OmitStartRecords | paOmitStartRecords | Long Integer | Long Int | 8 | |
| 12 | OmitLastRecords | paOmitLastRecords | Long Integer | Long Int | 8 | |
| 13 | paHeaderRowIndicator | paHeaderRowIndicator | String | paSTR10 | 10 | |
| 14 | paDeailRowIndicator | paDeailRowIndicator | String | paSTR10 | 10 | |
| 15 | NOTEINDX | Note Index | Currency | DLR14 | 14 | |
Key to the Record Notes Master (SY03900).
Click to show/hideSELECT
['Lockbox Master'].NOTEINDX AS 'Lockbox Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
palbmstr AS ['Lockbox Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Lockbox Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX | ||||||
| 16 | CREATDDT | Created Date | Date | DT | 8 | |
| 17 | MODIFDT | Modified Date | Date | DT | 8 | |