Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCVAT006
Product: Advanced VAT (2474)
Series: Purchasing
Display Name: NC_Payable_HDR
Physical Name: NCVAT006
Technical Name: NC_Payable_HDR
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length |
|---|
| 1 | DOCTYPE  | Document Type | DDL_Document_Type | Integer | 0 |
|
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo |
| 2 | VCHRNMBR | Voucher Number | STR20_LBAU | String | 20 |
| Partial key to the PM Key Master File (PM00400).
SELECT
['NC_Payable_HDR'].VCHRNMBR AS 'NC_Payable_HDR-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
NCVAT006 AS ['NC_Payable_HDR']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['NC_Payable_HDR'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['NC_Payable_HDR'].DOCTYPE = ['PM Key Master File'].DOCTYPE |
| 3 | PMTDSCIX | PM Trade Discount Index | LI_14 | Long Integer | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['NC_Payable_HDR'].PMTDSCIX AS 'NC_Payable_HDR-PM Trade Discount Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCVAT006 AS ['NC_Payable_HDR']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_Payable_HDR'].PMTDSCIX = ['Account Index Master'].ACTINDX |
| 4 | PMFRTIDX | PM Freight Index | LI_14 | Long Integer | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['NC_Payable_HDR'].PMFRTIDX AS 'NC_Payable_HDR-PM Freight Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCVAT006 AS ['NC_Payable_HDR']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_Payable_HDR'].PMFRTIDX = ['Account Index Master'].ACTINDX |
| 5 | PMMSCHIX | PM Misc Charges Index | LI_14 | Long Integer | 14 |
| Key to the Account Index Master (GL00105).
SELECT
['NC_Payable_HDR'].PMMSCHIX AS 'NC_Payable_HDR-PM Misc Charges Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
NCVAT006 AS ['NC_Payable_HDR']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['NC_Payable_HDR'].PMMSCHIX = ['Account Index Master'].ACTINDX |
| 6 | NC_Recalc_VAT | NC Recalc VAT | CB | Boolean | 0 |
