PO_VendorPurchaseAddress PO Vendor Purchase Address Rel: 4.40 Bld: 398 8/28/2009
Bus Obj: PO_VendorPurchaseAddress_bus
SQL Def: Y SysDB: N "MAS_"+%C$+"/PO"+%C$+"/PO_VendorPurchaseAddress.M4T"
KPRIMARY: APDivisionNo+VendorNo+PurchaseAddressCode
Fld Column Name M/L TUR Description/Notes Class
1 APDivisionNo. . . . . . . . . 2 SNY AP Division Number. . . . . . .APDIVISION
Mask:00 FmtType:ZEROFILL
Notes: {POB$(1,2)}
2 VendorNo. . . . . . . . . . . 7 SYY Vendor Number . . . . . . . . .VENDORNO
FmtType:MASTERNUM ChngTag:Rep
lace1/APDivisionNo$ Notes:
{POB$(3,7)}
3 PurchaseAddressCode . . . . . 4 SYY Purchase Address Code . . . . .PURCHASEADDRCODE
Notes: {POB$(10,4)}
4 PurchaseName. . . . . . . . . 30 SNN Purchase Name . . . . . . . . .NAME
Notes: {POB$(14,30)}
5 PurchaseAddress1. . . . . . . 30 SNN Purchase Address 1. . . . . . .ADDRESSLINE
Notes: {POB$(44,30)}
6 PurchaseAddress2. . . . . . . 30 SNN Purchase Address 2. . . . . . .ADDRESSLINE
Notes: {POB$(74,30)}
7 PurchaseAddress3. . . . . . . 30 SNN Purchase Address 3. . . . . . .ADDRESSLINE
Notes: {POB$(195,30)}
8 PurchaseCity. . . . . . . . . 20 SNN Purchase City . . . . . . . . .CITY
Notes: {POB$(104,20)}
9 PurchaseState . . . . . . . . 2 SYN Purchase State. . . . . . . . .STATE
Notes: {POB$(124,2)}
10 PurchaseZipCode . . . . . . . 10 SYN Purchase Zip Code . . . . . . .ZIPCODE
Notes: {POB$(126,10)}
11 PurchaseCountryCode . . . . . 3 SYN Purchase Country Code . . . . .COUNTRY
Notes: {POB$(225,3)}
12 BatchFax. . . . . . . . . . . 1 SYN Batch Fax . . . . . . . . . . .YESNO
DfltVal:N Valid:Y,N Notes:
{POB$(136,1)}
13 TelephoneNo . . . . . . . . . 17 SNN Telephone Number. . . . . . . .TELEPHONENO
Notes: {POB$(161,17)}
14 TelephoneExt. . . . . . . . . 5 SNN Telephone Extension . . . . . .TELEPHONEEXT
Notes: {POB$(146,5)}
15 FaxNo . . . . . . . . . . . . 17 SNN Fax Number. . . . . . . . . . .TELEPHONENO
Notes: {POB$(178,17)}
16 ContactCode . . . . . . . . . 10 SNN Contact Code. . . . . . . . . .APCONTACT
Notes: {POB$(151,10)}
17 TaxSchedule . . . . . . . . . 9 SYN Tax Schedule. . . . . . . . . .TAXSCHEDULE
Notes: {POB$(228,9)}
18 ExemptionNoOnFile . . . . . . 1 SYN Exemption Number On File. . . .YESNO
DfltVal:N Valid:Y,N Notes:
{POB$(237,1)}
19 EmailAddress. . . . . . . . . 50 SNN Email Address . . . . . . . . .EMAILADDRESS
20 DateCreated . . . . . . . . . 8 SNY Creation Date . . . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
21 TimeCreated . . . . . . . . . 8 SNY Creation Time . . . . . . . . .
Read Only:Y
22 UserCreatedKey. . . . . . . . 10 SYY Creation User ID. . . . . . . .USER
Read Only:Y Mask:0000000000
23 DateUpdated . . . . . . . . . 8 SNN Last Update Date. . . . . . . .DATE
Read Only:Y Notes: YYYYMMDD
24 TimeUpdated . . . . . . . . . 8 SNN Last Update Time. . . . . . . .
Read Only:Y
25 UserUpdatedKey. . . . . . . . 10 SNN Last Update User ID . . . . . .USER
Read Only:Y Mask:0000000000